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

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

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

      You are welcome.  If my previous reply helped, please mark it as Answer.

      • miiclaudia's avatar
        miiclaudia
        Regular Visitor
        5 years ago

        Hi All. 

        I need your support about this detail. My Totals didnt match. 

        The real total is 439K (Correct), but the total power bi gives $610. 

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Despues de dias de buscar este resultado, di con el usuario correcto, que alivio; Gracias Ashish_Mathur, como dirian en mi Pais, "MAQUINA"