Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello to all
This is probably a easy one.
I have a column that calculates the if a specific item meets the SLA defined. In my case 0 for no 1 for yes and for each item the month for that SLA achieved.
Now I want the SLA % by month but I'm getting 100%... always. 😞
My table is something like:
SLA Month
1 January
0 January
0 January
1 January
0 February
0 February
1 February
0 March
0 March
1 March
So SLA % for January should be 50%, both others should be 33%.
How can I get the correct value?
Thanks
Solved! Go to Solution.
@Anonymous
We can sum the SLA column to get the number of times SLA was achieved, then divide that by the number of rows to get the SLA %.
A measure like this should work:
SLA % = DIVIDE ( SUM ( YourTable[SLA] ), COUNTROWS ( YourTable ) )
Regards,
Owen
@Anonymous
We can sum the SLA column to get the number of times SLA was achieved, then divide that by the number of rows to get the SLA %.
A measure like this should work:
SLA % = DIVIDE ( SUM ( YourTable[SLA] ), COUNTROWS ( YourTable ) )
Regards,
Owen
Thanks For the quick reply.
It works as expected if I use the correct visualization.
Thanks
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |