divide cost TOTAL

[giuliapiazza94]

Hi guys,

I have a similiar case to divide cost of each customer

But, if I select a customer (for example Tony) I want to see 420, not 110, because I need to divide total cost for Tony

for example:

30% of 420 --> item A

70% of 420 --> item B

I tried to use ALL ( ) but if I expand matrix until to item the costs don't change

Can you help me?

[Anonymous]

Hi @giuliapiazza94 ,

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thanks in advance for your kind cooperation!

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@giuliapiazza94 ,

You need a measure like

calculate(sum(Table[Cost.Cost]), allselected())

In case you need switch between sub total  and grand total refer

https://xxlbi.com/blog/new-dax-function-isinscope/