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 UserHi 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✌️!!
gracie494Helper I
Helper IHello, thanks for responding. No there is no relationship between the tables