Create a new total column per specific row

[Anonymous]

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 :

What i want :

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 🙂

[Anonymous]

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 :

[DimaMD · Accepted solution]

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

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

[Anonymous]

It's perfect ! thanks for this solution

[DimaMD]

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

[DimaMD]

Hi @Anonymous 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)