% from two columns of pass/fail SLA rate

[erg24]

Hi,

I am struggling with being able to add a % for PASS and % for FAIL

I need to use the pass/fail and the count of ticket number to do this, I've tried various different ways however can't seem to get this right.

Thanks

Liz

[Anonymous · Accepted solution]

Hi @erg24 ,

Please try:

Measure = 
var _count=COUNTROWS('Table')
var _fail=CALCULATE(COUNTROWS('Table'),FILTER('Table',[Pass/Fail]="Fail"))
var _pass=CALCULATE(COUNTROWS('Table'),FILTER('Table',[Pass/Fail]="Pass"))
return IF(ISINSCOPE('Table'[Pass/Fail]),_count, DIVIDE(_fail,_pass))

If you want to set different format, please try:

format = 
var _count=COUNTROWS('Table')
var _fail=CALCULATE(COUNTROWS('Table'),FILTER('Table',[Pass/Fail]="Fail"))
var _pass=CALCULATE(COUNTROWS('Table'),FILTER('Table',[Pass/Fail]="Pass"))
return IF(ISINSCOPE('Table'[Pass/Fail]), FORMAT(_count,"##"), FORMAT(DIVIDE(_fail,_pass) ,"#.0%"))

But it returns Text type not Number type:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jennratten]

Here is a post that will likely help you.  If it does not, please provide more details showing the structure of your dataset, measures and provide an example.

https://community.powerbi.com/t5/Desktop/Percent-of-Total-Within-Hierarchy-Drilldown/m-p/777948