show total number for all matrix row

[Harry_Tran]

Hello everyone,

I have a matrix which has region as row procuct as row hierarchy, year as column, and total sale as value.

What I am trying to do is set the values of all products the same number with total.

What I mean is instead of showing 90,629.50 for C, 321,536.50 for E, 846,538.50 for G, and 699,109.00 for J. I would show 1,933,605.00 for all C, E, G, and J. 

Is there anyway to do that?

Thank you o much.

[Harry_Tran]

Allexcept works for my cenario, thank you so much everyone.

[parry2k]

@Harry_Tran it should be a simple measure like this:

//if you want slicer on catc to have the impact on the number
Sum = CALCULATE ( SUM ( 'Table'[Amount] ), ALLSELECTED ( 'Table'[Cat] ) ) 


//if you want don't want slicer on catc to have the impact on the number
Sum = CALCULATE ( SUM ( 'Table'[Amount] ), ALL ( 'Table'[Cat] ) ) 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous · Accepted solution]

HI @Harry_Tran 

measure = CALCULATE(sum('table'[total sale]), allexcept('table', 'table'[Region],'table'[year]))

[amitchandak]

@Harry_Tran , Assume you measure is M1 , which has these values

calculate([M1], allexcept(Table, Table[Region]))

or

calculate([M1], filter(allselected(Table), Table[Region] =max(Table[Region]) ))