Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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
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
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 @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,
Try this measure
Cost A = SUMX(SUMMARIZE(VALUES('Table'[DateTime]),[DateTime],"ABCD",[Price A]*[Value A]),[ABCD])
Hope this helps.
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.
Hi @Anonymous,
Please try this formula as a measure:
Measure = SUMX(VALUES('Table'[DateTime]),[Value A]*[Price A])
Hope it helps...
Ninter
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |