topic Re: Calculate or count rows of Measure = 100%. Measure is not part of the table. in DAX Commands and Tips

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

msarao — Mon, 26 Aug 2024 16:25:09 GMT

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%

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

ahadkarimi — Mon, 26 Aug 2024 16:30:01 GMT

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!

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

msarao — Mon, 26 Aug 2024 16:45:47 GMT

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%

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

ahadkarimi — Mon, 26 Aug 2024 20:34:11 GMT

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

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!