Forum Discussion

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
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
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
8 years ago
Hi,

If my reply helped, please mark it as Answer.

Interkoubess

Solution Sage

8 years ago

Hi Anonymous,

Could you please share your dummy data ( because an image is not easy to manipulate) and I will give a try.

Ninter

Anonymous

Not applicable

8 years ago

Thank you, Interkoubess. Please see the file path I added to the original post.

Interkoubess
Solution Sage
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
Super User
8 years ago
Hi,

Try this measure

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

Hope this helps.
- Anonymous
  Not applicable
  8 years ago
  Thank you!! I was not aware that I had to specify the column I wanted to summarize each row across (Table[DateTime]), it solved my problem!
  - Ashish_Mathur
    Super User
    8 years ago
    Hi,
    
    If my reply helped, please mark it as Answer.