DAX Sum based on another filter table

[gracie494]

How do I create a dax formula that displays the correct value for each row&Column rather than summarising the grand total. 

This is the fomula I attempted but it just sums up the Total rather than displaying the value for each RU

Column = IF(GAAP[Column1]="IFRS",CALCULATE(SUM(Grace_TEST_PBI[Values])) ,CALCULATE(SUM('Grace_TEST_PBI'[Values - IFRS17])))

[VahidDM]

Hi @gracie494 

Is there any relationship between GAAP and Grace_TEST_PBI tables?

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos✌️!!

[gracie494]

I just manually created that table to act as filter. So if someone selects 'IFRS' it will display the data based on the IFRS Value column, and if someone selected IFRSN it will show values in the IFRSN Values column

[VahidDM]

Those years on the columns are from the Grace_TEST_PBI table?

Can you share a sample of your tables here? [after removing sensitive data]

Appreciate your Kudos!!

[gracie494 · Accepted solution]

Thanks I managed to find a workaround by using Switch. Thanks for your help.

Measure 3 = SwITCH(SELECTEDVALUE(GAAP[GAAP]),"IFRS", [meas],"IFRS17",[Measure 2])

[gracie494]

Hello, thanks for responding. No there is no relationship between the tables