Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

incorrect Grand Total

My Dax is returning  incorrect Grand Total.  Can anyone help review or rewrite it.  Demo = IF (     HASONEVALUE ( 'Report Currency'[Report Currency] ),     SUMX (         'Exchange Rates',     ...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous 

Brother, would you please place a screenshot of your data model along with the relationships?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

tamerj1  The relationship  is 1: *  live connection. 

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Anonymous 

    The formula contains three tables. Please provide complete information