Forum Discussion
gracie494
Helper I
Helper IDAX Sum based on another filter table
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 d...
- 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])
VahidDM
Super User
Super UserThose 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!!
gracie494Helper I
Helper IThanks I managed to find a workaround by using Switch. Thanks for your help.
Measure 3 = SwITCH(SELECTEDVALUE(GAAP[GAAP]),"IFRS", [meas],"IFRS17",[Measure 2])