Forum Discussion

matsahiro's avatar
matsahiro
Icon for Helper II rankHelper II
5 years ago

DAX Calculating on Wrong Rows - Not Recognizing Join Relationship Properly

Hello, I'm trying to figure out why DAX isn't calculating properly on the right rows. I have this indicator made in DAX trying to show which accounts have different dates from previous and current da...
matsahiro's avatar
matsahiro
Icon for Helper II rankHelper II
5 years ago

amitchandak I went ahead and created the common account table and added indexes to the other two tables. I joined on the indexes with ID in account table. Here's what the relationship looks like. 

The relationships looks to be right until I add in the indicator. 

 

matsahiro's avatar
matsahiro
Icon for Helper II rankHelper II
5 years ago

 

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    matsahiro , Make these 1-1 Join as 1-M (account is 1), single direction and try 

    • matsahiro's avatar
      matsahiro
      Icon for Helper II rankHelper II
      5 years ago

      Unfortunately when I establish the relationships like that, the visual breaks even without the indicator included in the visual.