Calculate(Countrows) with Filter ignoring row context?

[joe1255]

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

[joe1255 · Accepted solution]

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

[Anonymous]

Hi @joe1255 ,

Glad to hear you have resolved the problem.

Best Regards,

Ada Wang