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.

TomMartens's avatar
TomMartens
Super User
8 years ago

Hey,

 

I'm wondering if this would solve your problem:

Tot cost A [EUR] =
SUMX(
    'name of your table'
    ,[Volume A [MWh]]*[Price A [EUR/MWh]]
)

Regards,

Tom