Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Analysis Outcome |
Does Not Comply |
Does Not Comply |
Does Not Comply |
Does Not Comply |
Does Not Comply |
Does Not Comply |
Does Not Comply |
Does Not Comply |
Does Not Comply |
Does Not Comply |
Does Not Comply |
Complies |
Complies |
Complies |
Complies |
Complies |
Complies |
Complies |
Complies |
Complies |
Complies |
Complies |
Complies |
Complies |
Complies |
Complies |
Complies |
Complies |
Complies |
Complies |
Complies |
Complies |
Complies |
Complies |
Complies |
Hi,
Share the link from where i can download your PBI file.
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.
Thany ou very much but that is not what i am looking for
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.
Could provide more datails?
Best Regards,
Link
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
Nemanja
Thank you very much for your input. I have tried your suggestion and it does change the end results, it gives the same output as my original measure.
Regards,
Chris
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |