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

Need Help
  • Archana007's avatar
    Archana007
    2 years ago

    Ah.. this worked

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

2 Replies

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