Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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.

Appreciate your Kudos.

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.

## Helpful resources

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors