removing Other group from total caluclation

[Anonymous]

Hello. I have a matrix that looks like this

product 1	5%
product 2	5%
product 3	10%
other	80%
total	100%

End user asked me to show matrix like this.

product 1	5%
product 2	5%
product 3	10%
total	20%

Any ideas how can I remove row other?

I've created filter that I'll hide from end user and it helps me to show matrix like this

product 1	5%
product 2	5%
product 3	10%
total	100%

but for some reason power bi still calculates total with other field and shows 100% instead of 20%. Could you please help me to show 20% in total. It's not necessary to use filter, may be other solution. How does power bi calculates total? is it possible to change it's formula? Numbers in my value column are measure if it matters.

Thanks  alot in advance!!!

[mwegener]

Hi @Anonymous ,

How do you calculate the percentage?

Can you provide sample data?

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[Anonymous]

@mwegener 

	qty	total qty	%
product 1	20	100	=20/100'
product 2	15	100	=15/100'
product 3	5	100	=5/100'
other	60	100	=60/100'
total	100		100%

all cells are measures. But for end user I don't show calculation, only % column.Thanks a lot in advance!

[mwegener · Accepted solution]

Hi @Anonymous 

check this out.

PBIX

But I think it's because of your measures.

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[Anonymous]

@mwegenerThanks a lot! In your table it works fine, thank you. But for some reason in my case it's not working...Is it possible that it's not working becasue I have matrix with drill down?If yes, is there any way to fix my total?Thanks a lot in advance!

[Anonymous]

@mwegenerWhen I applied filter to your file, everything worked perfect. But for sme reason I'm still getitng this result. I cannot apply your total formula, becasue in columns I have date hierarchy, in rows product type.Any ideas why it's not working in my file? Thanks a lot in advance!!

	qty	total qty	%
product 1	20	100	=20/100'
product 2	15	100	=15/100'
product 3	5	100	=5/100'
total	100		100%

[mwegener]

Hi @Anonymous ,

is your problem solved?
Otherwise, you can provide some more information about your measures and your model.

[Anonymous]

Hi @mwegener  Thanks a lot for your help. In my measure calculation I had allexept and forgot to add my filter to allexcept. Thanks a lot!