Forum Discussion
Calculate switching between brands
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.
Super Useride , Not able to find logic between input and output. The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
Hi amitchandak to be clear i have same confusion.
I believe it should be different datasample in input. Idea is to have knowledge about switching between brands. All i got is screenshot with same approach, but made in different system. Unfortunately, have no option to got anwers from customer. Probably anyone here had faced something like this.
Explaination for 1st row almost the same as in my example.
Sales for J_Бренд_B higher than J_Бренд_A, sales for J_Бренд_C smaller than J_Бренд_A and so on.
How it can be, in excel example
V-lianl-msftCommunity Support
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.
