Forum Discussion

gracie494's avatar
gracie494
Icon for Helper I rankHelper I
4 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 displaying the value for each RU

 

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

 

  • gracie494's avatar
    gracie494
    4 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])

5 Replies

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    4 years ago

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

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

       

    • gracie494's avatar
      gracie494
      Icon for Helper I rankHelper I
      4 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
        4 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!!