Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have created a measure if compliance is 100%.
Which is not part of the table.
Depending on the filters (months week empmid) , i need to count all that is 100%
Solved! Go to Solution.
Hi @msarao, create the two measures below, try them out, and let me know if there are any issues.
Compliance Measure = IF(SUM('ComplianceTable'[ComplianceValue]) = 100, 1, 0)
Count of 100% Compliance =
CALCULATE(
COUNTROWS('ComplianceTable'),
'ComplianceTable'[Compliance Measure] = 1
)
Did I answer your question? If so, please mark my post as the solution!✔️
Your Kudos are much appreciated! Proud to be a Responsive Resident!
Error - A function "Placeholder" has veen used in a teue/false exception that is used as a table filter expression.
I just want a count of 100%
User | Count |
---|---|
14 | |
9 | |
7 | |
7 | |
6 |
User | Count |
---|---|
21 | |
11 | |
10 | |
10 | |
8 |