Forum Discussion

joe1255's avatar
joe1255
New Member
2 years ago
Solved

Calculate(Countrows) with Filter ignoring row context?

Hi All, this works in Excel and I can't for the life of me figure out why it's not working in BI, all of the googling I've done leads me to believe the syntax is correct, but instead of returning the count by row context, it's returning the total row count for the table (with the filter criteria) for each row in my matrix...?

 

My Measure... 

Complete Count = CALCULATE(COUNTROWS('All Workflows'),FILTER('All Workflows','All Workflows'[Status]="Complete"))

 

My Results...

 

There are 2872 completed records in my source table, but why is it ignoring the row context of my matrix? all of my other measures seem to be working as expected...?

 

Thanks,

Joe

 

  • Never mind, figured it out, relationship between tables wasn't set right.

2 Replies

  • Never mind, figured it out, relationship between tables wasn't set right.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi joe1255 ,

      Glad to hear you have resolved the problem.

      Best Regards,

      Ada Wang