topic Re: divide cost TOTAL in DAX Commands and Tips

divide cost TOTAL

giuliapiazza94 — Mon, 15 Nov 2021 11:31:04 GMT

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?

Re: divide cost TOTAL

amitchandak — Mon, 15 Nov 2021 12:42:57 GMT

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/

Re: divide cost TOTAL

Anonymous — Fri, 19 Nov 2021 09:31:12 GMT

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.