Get total and subtotal right in measures

[Anonymous]

Hi,

I kindly need your help on this

So currently I have this display on my PowerBI table. To calculate the Amount 1 of candy, coffee, etc I already have a measure for that let's say the measure is called [Amount 1]

Let's say A, B is Category 1

Then Candy, Coffee, Biscuit are Brand

So if I only put Measure [Amount 1], I didn't get the subtotal and total correct.

Then in order to get the total and subtotal of A and B right, I have another measure using:

Amount 2 = if(HASONEVALUE(Table[Brand]), [Amount 1], sumx(values(Table[Brand]), [Amount 1]))

But after I display the amount 2, the subtotal of A & B is already correct, but the total is wrong.

What can I do about this? Thank you so much

[mahoneypat · Accepted solution]

Please see this video.

(2) Power BI - Tales from the front #01 - Getting the Right Total - YouTube

Pat

[Anonymous]

Hi, this video is actually helping! Thank you so much

[Jos_Woolley]

Hi,

Can you share the definition of [Amount 1]? Also, can we see what the visual looks like with just [Amount 1], so that we can see the 'incorrect' subtotals and totals?

Regards