% Calculation from a Column with Mixed Values

Hi Chitemerere ,
Try changing variable for Complying by adding filter part:
CALCULATE (
    DISTINCTCOUNT ( 'Quality Facts'[Sample No#] ),
    Filter('Quality Facts', 'Quality Facts'[Analysis Outcome] = "COMPLIES")
)

Regards,
Nemanja Andic

Hi Chitemerere,

I’m not clear your data structure.

What condition value does ‘AllComplying’ return?

It returns 100% when [Sample No#] are Non-duplicate values in your measure.

Try measure as:

Complying % =

var Complying =

CALCULATE(

    COUNTROWS('Quality Facts'),

FILTER(

    ALL('Quality Facts'),

    'Quality Facts'[Analysis Outcome]="Complies"

)

)



var Allcomplying=

CALCULATE(

    COUNTROWS('Quality Facts'),

    ALL('Quality Facts')

)



RETURN

Complying/Allcomplying

Here is the output:

Here is the demo, please try it: % Calculation from a Column with Mixed Values

Best Regards,

Link

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

Hi,

Share the link from where i can download your PBI file.