Forum Discussion
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...
Hi Anonymous,
Please try this formula as a measure:
Measure = SUMX(VALUES('Table'[DateTime]),[Value A]*[Price A])Hope it helps...
Ninter
Hi,
Try this measure
Cost A = SUMX(SUMMARIZE(VALUES('Table'[DateTime]),[DateTime],"ABCD",[Price A]*[Value A]),[ABCD])
Hope this helps.
Hi,
If my reply helped, please mark it as Answer.
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!
Hi,
If my reply helped, please mark it as Answer.