cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ValentintT
New Member

Create a new total column per specific row

Hello,

I need some help for summarize row in a new column with a condition on rows

The logic is : Sum for each product the value of BRAND A & BRAND B and put in every row

What i have :

ValentintT_0-1669795934840.png

 

What i want :

ValentintT_1-1669795965815.png


Sum of product A BRAND A + product A BRAND B = 15

Sum of product B BRAND A + product B BRAND B = 50

 

Thanks for your help 🙂

 

1 ACCEPTED SOLUTION

@ValentintT Then try this Measure, also attached an example file

 

 

Measure = 
  CALCULATE( SUM('Table'[Value]), 'Table'[BRAND] in  {"A","B"} , ALLEXCEPT('Table','Table'[Product]))

 

 

Screenshot_15.jpg


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

View solution in original post

5 REPLIES 5
ValentintT
New Member

Thanks for your help

But i expressed my problem badly
I need it for every products but A and B aren't the only products :

ValentintT_0-1669800097415.png

 



 

@ValentintT Then try this Measure, also attached an example file

 

 

Measure = 
  CALCULATE( SUM('Table'[Value]), 'Table'[BRAND] in  {"A","B"} , ALLEXCEPT('Table','Table'[Product]))

 

 

Screenshot_15.jpg


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

It's perfect ! thanks for this solution

@ValentintT How many products do you have in the table? 


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine
DimaMD
Super User
Super User

Hi @ValentintT try it

Measure = 
 VAR BR_a = CALCULATE( SUM('Table'[Value]), 'Table'[BRAND] = "A" &&  'Table'[Product] = "A") + CALCULATE( SUM('Table'[Value]), 'Table'[BRAND] = "B" &&  'Table'[Product] = "A")
 VAR BR_b = CALCULATE( SUM('Table'[Value]), 'Table'[BRAND] = "A" &&  'Table'[Product] = "B") + CALCULATE( SUM('Table'[Value]), 'Table'[BRAND] = "B" &&  'Table'[Product] = "B")
 return
 IF( SELECTEDVALUE('Table'[Product]) = "A", BR_a ,BR_b)

Screenshot_13.jpg


__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.