Measure Incorrect when selecting option in Slicer

[Michael117]

Hello All,

I have a measure that calculates the % of completed tasks that have achieved SLA, When i use my Slicer to choose "CAT 2 Achieved SLA" it shows correct value, but when i select "CAT 2 Missed SLA" the slicer shows an Incorrect value. I would like the value to show as 0% when anything other than "CAT 2 Achieved SLA" is selected.

Thanks in advance!

<<<<< PBIX file >>>>> 

CAT 2 SLA Achieved % = 
var CAT2A=
    CALCULATE(
        COUNT('Master AllCSA-ExternalOPEX'[Is Job within SLA]),
        'Master AllCSA-ExternalOPEX'[Is Job within SLA]="CAT 2 Achieved SLA"
    )
    return
var CAT2AT=
    CALCULATE(
        COUNT('Master AllCSA-ExternalOPEX'[CATEGORY]),
        'Master AllCSA-ExternalOPEX'[CATEGORY]="CAT 2",
        'Master AllCSA-ExternalOPEX'[Status]="Completed"
    )
    return
var CAT2AP=
    CALCULATE(
        (CAT2A/CAT2AT)
    )
    return
    IF(
        ISBLANK(
            CAT2AP),
            "0%",
            IF(
                ISERROR(
                    CAT2AP),
                    "0%",
                    CAT2AP)
                    )

Card that shows Measures with incorrect valueTable I created to help identify what the issue may be.SLA Slicer based from a calculated column

[amitchandak]

@Michael117 , where is code for CAT 2 Missed SLA.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

May be you leave condition on selected value - selectedvalue(Slicer[slicer])

CAT 2 SLA Achieved % = 
var CAT2A=
    CALCULATE(
        COUNT('Master AllCSA-ExternalOPEX'[Is Job within SLA]),
        'Master AllCSA-ExternalOPEX'[Is Job within SLA]=selectedvalue(Slicer[slicer])
    )
    return
var CAT2AT=
    CALCULATE(
        COUNT('Master AllCSA-ExternalOPEX'[CATEGORY]),
        'Master AllCSA-ExternalOPEX'[CATEGORY]="CAT 2",
        'Master AllCSA-ExternalOPEX'[Status]="Completed"
    )
    return
var CAT2AP=
    CALCULATE(
        (CAT2A/CAT2AT)
    )
    return
    IF(
        ISERROR(
            CAT2AP),
            "0%",
            CAT2AP)

[Michael117]

Hello @amitchandak ,

I just tried to add Selectedvalue to the formula and received this error;

"A function 'SELECTEDVALUE' has been used in a True/False expression that is used as a table filter expression. This is not allowed."

I'm still working on setting up the test pbix for you. Thanks

[amitchandak]

@Michael117 , Try in the filter

CAT 2 SLA Achieved % = 
var CAT2A=
    CALCULATE(
        COUNT('Master AllCSA-ExternalOPEX'[Is Job within SLA]),
        filter('Master AllCSA-ExternalOPEX','Master AllCSA-ExternalOPEX'[Is Job within SLA]=selectedvalue(Slicer[slicer]))
    )
    return
var CAT2AT=
    CALCULATE(
        COUNT('Master AllCSA-ExternalOPEX'[CATEGORY]),
        'Master AllCSA-ExternalOPEX'[CATEGORY]="CAT 2",
        'Master AllCSA-ExternalOPEX'[Status]="Completed"
    )
    return
var CAT2AP=
    CALCULATE(
        (CAT2A/CAT2AT)
    )
    return
    IF(
        ISERROR(
            CAT2AP),
            "0%",
            CAT2AP)

[Michael117]

Hi @amitchandak ,

The filter with selected value didn't achieve the desired outcome. I have added a link to the PBIX file in OP and below;

<<<<< PBIX FILE >>>>>