Calculate switching between brands

[ide]

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!

[amitchandak]

@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.

[ide]

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.

[ide]

How it can be, in excel example

[V-lianl-msft · Accepted solution]

Hi @ide ,

Create four measures similar to this

Brand A = SUM('Table'[Sum])-
 CALCULATE(SUM('Table'[Sum]),FILTER(ALLSELECTED('Table'),'Table'[Brand]="Brand_A" ))

Sample .pbix

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ide]

P.S. data in "what i want to get" chapter is invented.