Help with figuring/creating a measure

Question

Hello,&nbsp;I'm inexperienced with PBI and I'm trying to create a percentage value in a matrix visual.&nbsp;The DB data is something like this:IDdetailssla met1problem1&nbsp; &nbsp; &nbsp; &nbsp; 02problem2&nbsp; &nbsp; &nbsp; &nbsp; 13problem2&nbsp; &nbsp; &nbsp; &nbsp; 14problem1&nbsp; &nbsp; &nbsp; &nbsp; 15problem3&nbsp; &nbsp; &nbsp; &nbsp; 06problem3&nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp;The matrix I'm using has the 'details' as rows, the 'sla met' as columns and the count of 'sla met' as values, showing something like:details01totalproblem1&nbsp; 1&nbsp; 1&nbsp; 2problem2&nbsp;&nbsp; 2&nbsp; 2problem3&nbsp; 2&nbsp;&nbsp; 2&nbsp;What I need to have is a measure that divides value in the '1' column by the total, so i can have a percentage of '1' column vs. total.&nbsp;Is there a way of doing this? I'm using PBI service included in Microsoft Fabric.&nbsp;Thanks in advance.

martin_d · Accepted Answer

Hi&nbsp;
&nbsp;
The easiest way would be to right-click on the field in the values configuration of the matrix visual and choose display as percentage of row as described here:&nbsp;https://www.popautomation.com/post/power-bi-percentage-of-total#:~:text=identify%20a%20calculation.-,Note%3A,-If%20you%20double
&nbsp;

&nbsp;
If you want to write a measure, this would be the code:Pct. SLA Met =VAR _SlaCountInContext =&nbsp; &nbsp; COUNTROWS ( Table )VAR _SlaCountAll =&nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; COUNTROWS ( Table ),&nbsp; &nbsp; &nbsp; &nbsp; REMOVEFILTERS (Table[sla met] ))RETURN
DIVIDE (&nbsp;_SlaCountInContext,&nbsp;_SlaCountAll )BR
Martin

Forum Discussion

Help with figuring/creating a measure

1 Reply

Related content

Creating a chart for rolling figure in date format

Create measure to calculate the full year figure of budget

Measure

DAX Measure

Path Measure

ID	details	sla met
1	problem1	0
2	problem2	1
3	problem2	1
4	problem1	1
5	problem3	0
6	problem3	0