Show percentage in a matrix with 2 levels

[Anonymous]

Dear everyone,

I have checked a solution to my problem in all the messages, but I didn't find it. I hope that someone can help me.

I have this sort of table:

Code	Month	Market	Rules
T1	January	Germany	Follow rules
T2	January	Italy	Don't follow rules
T3	January	Germany	Follow rules
T4	January	Germany	Don't follow rules
T5	January	Italy	Don't follow rules
T6	January	Italy	Follow rules
T7	February	Germany	Follow rules
T8	February	Germany	Don't follow rules
T9	February	Italy	Follow rules
T10	February	Italy	Don't follow rules

For sure, my table has thousands of lines and hundred of Market. I want to show a matrix with the percentages for each Market (and not the total of the column) like below:

	January	February
Germany	100%	100%
- Follow rules	67%	50%
- Don't follow rules	33%	50%
Italy	100%	100%
- Follow rules	33%	50%
- Don't follow rules	67%	50%

I have created a matrix with these info:

Rows:

- Market

- Rules

Colums:

- Month

Values:

- Count of "Rules" and Shows values as Percentage of column total

But it shows the percentage of all the column, which is not what I want as I have hundred of markets...

Can you please help me ?

Thank you very very much for your help

Isabelle

[parry2k · Accepted solution]

@Anonymous here are the measures

c = COUNTROWS ( Table )

% = DIVIDE( [c], CALCULATE ( [c], ALL ( Table[Rules] ) ))

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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]

Dear @parry2k 

Thank you so so much for your super quick answer. It works !!! I understand know the measures...

I have only a problem, it shows "0.13" instead of "13%". I have checked in the "Field formatting"/"Display unit" part, but it allows only "Thousands, Millions, ...". Do you know how to display them as "real" percentages ?

Thank you very much and best regards

Isabelle

[parry2k]

@Anonymous the measure/column you used to show values, what is the format of that measure, if that is %, it will show in %, and you can change the format of column/measure by selecting it in the field pane, on right hand side and change format on measure/column tools on the menu.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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]

Dear @parry2k 

Thank you very much ! In fact, I have used another measure to put the right format:

Measure = FORMAT([measure-percent],"###%")

Thank you very much for all your help on this topic !