Calculate(Countrows) with Filter ignoring row context?

joe1255 — Tue, 18 Jun 2024 20:37:00 GMT

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

Re: Calculate(Countrows) with Filter ignoring row context?

joe1255 — Tue, 18 Jun 2024 21:33:22 GMT

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

Re: Calculate(Countrows) with Filter ignoring row context?

Anonymous — Wed, 19 Jun 2024 01:20:03 GMT

Hi joe1255 ,

Glad to hear you have resolved the problem.

Best Regards,

Ada Wang

topic Re: Calculate(Countrows) with Filter ignoring row context? in DAX Commands and Tips

Calculate(Countrows) with Filter ignoring row context?

Re: Calculate(Countrows) with Filter ignoring row context?

Re: Calculate(Countrows) with Filter ignoring row context?