Forum Discussion
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 :
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 Then try this Measure, also attached an example file
Measure = CALCULATE( SUM('Table'[Value]), 'Table'[BRAND] in {"A","B"} , ALLEXCEPT('Table','Table'[Product]))
5 Replies
DimaMDSolution Sage
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)