Search code examples
powerbidaxdata-analysispowerbi-desktopdata-cleaning

Related() with 2 differents Tables

_Hi, I have two simple separate tables connected with a one-to-many relation. When I try to add a calculated column to the fact table with a related DAX formula, the result is all blank. However, when I create a reference table from the Facts one, an do the same, then it works. I can't understand why the first one does not work : it is as if there were no relation between the 2 tables ?

Thanks in advance for your help. Here is the link to my PBIX file.

Solution

  • You have different values in the columns. Observe:

    enter image description here

    enter image description here

    enter image description here

    I suggest you properly clean your data in PQ.