Incorrect total using measure

[Anonymous]

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

[Interkoubess · Accepted solution]

Hi @Anonymous,

Please try this formula as a measure:

Measure = SUMX(VALUES('Table'[DateTime]),[Value A]*[Price A])

Hope it helps...

Ninter

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

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

Hope this helps.

[Anonymous]

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

[v-yuta-msft]

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

[TomMartens]

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

[Interkoubess]

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]

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

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

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

Hope this helps.

[Anonymous]

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 · Accepted solution]

Hi,

If my reply helped, please mark it as Answer.

[Interkoubess · Accepted solution]

Hi @Anonymous,

Please try this formula as a measure:

Measure = SUMX(VALUES('Table'[DateTime]),[Value A]*[Price A])

Hope it helps...

Ninter