Forum Discussion
Solved
Calculate switching between brands
Hi guys, Is it possible to make following thing happen.... What data i have: Brand sum Brand_A 2309 Brand_B 2342 Brand_C 1234 Brand_D 257 What i want to build in p...
Hi ide ,
Create four measures similar to this
Brand A = SUM('Table'[Sum])- CALCULATE(SUM('Table'[Sum]),FILTER(ALLSELECTED('Table'),'Table'[Brand]="Brand_A" ))Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
P.S. data in "what i want to get" chapter is invented.