Countrows not working as expected

[Archana007]

Hi,

I'm creating two measure on the same column which has only two values 0 or 1 for all rows.

Measure 1:

COUNTROWS( filter('Audit plan 2024','Audit plan 2024'[AuditCount] = 0)) --Returns the count

Measure 2:

COUNTROWS( filter('Audit plan 2024','Audit plan 2024'[AuditCount] = 1)) doesn't return the count.

I'm using PowerBI desktop.

Does this have anything to do with Liscensing?

I'm getting out put in dax query:

Please share your thoughts. Thanks in advance.

Thanks,

Archana

[Archana007 · Accepted solution]

Ah.. this worked

CALCULATE(COUNTROWS('Audit plan 2024'), 'Audit plan 2024'[AuditCount]=1)

[Anonymous]

@Archana007 Glad you have solved it! You can accept your reply as solution to close this thread. Thank you.