Forum Discussion

gracie494's avatar
gracie494
Icon for Helper I rankHelper I
5 years ago
Solved

DAX 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...
  • gracie494's avatar
    gracie494
    5 years ago
    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's avatar
gracie494
Icon for Helper I rankHelper I
5 years ago

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's avatar
VahidDM
Icon for Super User rankSuper User
5 years ago

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's avatar
    gracie494
    Icon for Helper I rankHelper I
    5 years ago
    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])