Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
msarao
Regular Visitor

Calculate or count rows of Measure = 100%. Measure is not part of the table.

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% 

1 ACCEPTED SOLUTION
ahadkarimi
Solution Specialist
Solution Specialist

@msarao  here is the sample, if you encounter any issues or want to know how to do it, let me know.
ahadkarimi_0-1724704279628.png

you can download the pbix file from here.

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!

View solution in original post

3 REPLIES 3
ahadkarimi
Solution Specialist
Solution Specialist

 

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%

IMG_7018.jpeg

ahadkarimi
Solution Specialist
Solution Specialist

@msarao  here is the sample, if you encounter any issues or want to know how to do it, let me know.
ahadkarimi_0-1724704279628.png

you can download the pbix file from here.

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!

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.