Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |