Matrix with multiple months and percentages

[Anonymous]

Hello community,

I have a problem and I think it would be not so hard, but I haven't yet experience with this tool.

I have a Matrix with following elements (from the visualizations pane)

• Rows: Customers
• Columns: Status (can be OK or KO), Month.
• Values: Number of IDs (count of those unique identifiers) , % (percentage of those IDs on the total).

If I select one month, I have (say)

status	KO		OK		TOTAL
month	october
customer	N	%	N	%
AAA	20	20%	80	80%	100%

But If I select more than one month (say two) I need to have that every month sum up at 100% in every subtotal. Instead, I obtain the percentage of grand total and that's not what I want..

THere is a Measure I could create to achieve this goal?

Thanks in advance!

[V-lianl-msft · Accepted solution]

You can try to create a measure like below:

Measure = 
var current_ = DISTINCTCOUNT('Table'[ID])
var total_per_month = CALCULATE(DISTINCTCOUNT('Table'[ID]),ALLEXCEPT('Table','Table'[Month]))
return DIVIDE(current_,total_per_month)

[amitchandak]

@Anonymous , Try a measure like

divide(count(Table[unique identifiers]) ,calculate( count(Table[unique identifiers]), removefilters(Table[Status])) )