Forum Discussion
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 power bi - "switching between brands". For 1st row (Brand_A) it tells that sales for Brand_B is higher (+500) compare to Brand_A, sales for Brand_C are smaller (-200), sales for Brand_D again higher.
| Brand_A | Brand_B | Brand_C | Brand_D | |
| Brand_A | 500 | -200 | 345 | |
| Brand_B | 113 | 324 | -783 | |
| Brand_C | 245 | 356 | 234 | |
| Brand_D | 756 | -234 | 75 |
Prob, i need to add something in my dataset, like customer ID or something. Any ideas?
Thanks!
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.
5 Replies
P.S. data in "what i want to get" chapter is invented.
- amitchandak
Super User
ide , 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
