Forum Discussion
Helper IVdivide cost TOTAL
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?
You need a measure like
calculate(sum(Table[Cost.Cost]), allselected())
In case you need switch between sub total and grand total refer
2 Replies
- amitchandak
Super User
You need a measure like
calculate(sum(Table[Cost.Cost]), allselected())
In case you need switch between sub total and grand total refer
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 _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
