Forum Discussion

Archana007's avatar
Archana007
New Member
2 years ago
Solved

Countrows not working as expected

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 t...
Need Help
  • Archana007's avatar
    Archana007
    2 years ago

    Ah.. this worked

    CALCULATE(COUNTROWS('Audit plan 2024'), 'Audit plan 2024'[AuditCount]=1)
Archana007's avatar
Archana007
New Member
2 years ago

Ah.. this worked

CALCULATE(COUNTROWS('Audit plan 2024'), 'Audit plan 2024'[AuditCount]=1)
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

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