Forum Discussion
Microsoft EmployeeGet percentage by Column Total in Matrix
Hi abbynie08
According to summary by Greg_Deckler :
This is almost certainly caused by what is referred to as “the measure totals problem”. This one is extremely common. See this post that explains it, Dealing with Measure Totals
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need.
Matrix Measure Total Triple Threat Rock & Roll (MM3TR&R) can also be useful.
Or this Quick Measure submission, Table Matrix Totals or Subtotals.
If it is sloved, could you kindly accept it as a solution to close this case and help the other members find it more quickly?
If not, please feel free to let me know.
Best Regards
Maggie
Super UserTry your measure with a KEEPFILTERS added.
Perent of Total =
DIVIDE (
DISTINCTCOUNT ( 'Table'[Orders] ),
CALCULATE (
DISTINCTCOUNT ( 'Table'[Orders] ),
KEEPFILTERS ( ALLEXCEPT ( 'Table', [Country] ) )
)
)
abbynie08Thank you for replying. Unfortunately, this does not work. The percentages in the matrix are all 100%. I tried to create a measure of half of your code, which list below to see why that happens.
Column Total = CALCULATE ( DISTINCTCOUNT ( 'Table'[Orders] ), KEEPFILTERS ( ALLEXCEPT ( 'Table', [Country] ) ) )It seems that the value returned are just as the first table that I put in my post, which is the same as distinctcount('Table' [Orders]). Can you help me with this? Thanks