cancel
Showing results for
Did you mean:
Regular Visitor

## 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!

1 ACCEPTED SOLUTION
Community 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" ))``````

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.

5 REPLIES 5
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.

New Power BI Features
Datamarts: https://youtu.be/8tskWsJTEpg
Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Dashboard of My Blogs !! Connect on Linkedin !! Proud to be a Super User!
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
!! Subscribe to my youtube Channel !!
Regular Visitor

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.

Regular Visitor

How it can be, in excel example

Community 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" ))``````

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.

Regular Visitor

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