Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Incorrect total using measure

Hi,   I am struggling with calculating the correct measure total, because Power BI applies the measure on the totals line instead of summarizing the result per line. I do not get any values if I us...
Need Help
  • Interkoubess's avatar
    Interkoubess
    8 years ago

    Hi Anonymous,

     

    Please try this formula as a measure:

    Measure = SUMX(VALUES('Table'[DateTime]),[Value A]*[Price A])

    Hope it helps...

     

    Ninter

  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this measure

     

    Cost A = SUMX(SUMMARIZE(VALUES('Table'[DateTime]),[DateTime],"ABCD",[Price A]*[Value A]),[ABCD])

     

    Hope this helps.

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    If my reply helped, please mark it as Answer.

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi CR1,

 

I use sumx but it works well on my side, so could you post your measure of [Volume A [MWh] and [Price A [EUR/MWh]?

 

 

Regards,

Jimmy Tao