Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Dealing with Measure Totals

This one has come up quite a bit recently. The issue surrounds using Measures in Table visualizations with a Total row. The complaint is that the "Total" row is "wrong" for the measure. Technically, ...
bob_by's avatar
bob_by
New Member
5 years ago

Hi,

 

I'm strugging with the issue where I need to calculate one measure in a two ways based on the values.

 

The data model is much more complex, however to simplify it let's imagine that I have one column and two measures.If value in column is "D" pick value from second measure, otherwise first measure.

When I use below formula the row by row calulation is good however total is wrong. 

 

Measureif = IF(SELECTEDVALUE('Table'[Column1])="D",[Measure2],[Measure1] )

 

I need to present all values in table and I cannot make columns instead of measures. I understand what SELECTEDVALUE is doing however don't know what other formula should I use n that case. 

 

All suggestions are more than welcomed.

 

Thank you

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

The result of the Measureif measure is correct.  What problem are you facing? 

  • bob_by's avatar
    bob_by
    New Member
    5 years ago

    Hello,

    the total value is wrong.

    bobby

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      5 years ago

      Hi,

      Try this measure

      =SUMX(VALUES(Table[Column1]),[Measureif])

      Hope this helps.

      • bob_by's avatar
        bob_by
        New Member
        5 years ago

        Ashish_Mathur you saved my day 😀

        Thank you