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 use SUMX(measure1 * measure2) (maybe because SUMX does not work on measures). Does anybody please have a suggestion how I can solve the problem? Thank you!
Case
Measure 1= [Price A] = AVERAGEX(Filter('Table'; 'Table'[ID]=100); [Value])
Measure 2= [Value A ]= SUMX(Filter('Table'; 'Table'[ID]=101); [Value])
Measure 3 = [Price A] * [Value A ]
Total in Power BI: 25*442.74=11269,472
Total I need: Sum of all rows=11285,84
Dummyfile: https://www.dropbox.com/s/k5fu3amb1whff7h/PowerBI_dummyData_01082018.pbix?dl=0
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.
9 Replies
Hi Anonymous,
Could you please share your dummy data ( because an image is not easy to manipulate) and I will give a try.
Ninter
Thank you, Interkoubess. Please see the file path I added to the original post.
Hi Anonymous,
Please try this formula as a measure:
Measure = SUMX(VALUES('Table'[DateTime]),[Value A]*[Price A])Hope it helps...
Ninter
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
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
Hi,
Thanks for input- I have tried to make the original post more precise. Please see my dummyfile (it did not work with SUMX): https://www.dropbox.com/s/k5fu3amb1whff7h/PowerBI_dummyData_01082018.pbix?dl=0
