Forum Discussion

Txtcher's avatar
Txtcher
Helper V
1 year ago
Solved

DAX Newbie Count Rows by Date Filter

I am using Excel Power Query / Data Model and I am brand new to DAX. I have 3 queries: Date_table CasesSent CasesClosed The CasesSent table has 2 dates, Sent Date & Due Date. The Cases Closed t...
Dax Help
  • Txtcher's avatar
    Txtcher
    1 year ago

    Posting to state that after much research, I have solved the problem.  I have one date table that has multiple relationships with the other table. When creating formulas involving "inactive" relationships, I needed to active that relationship.

    Example:  Cases Due:=CALCULATE(
    COUNTROWS('RS Cases'),USERELATIONSHIP(Date_Table[Date],'RS Cases'[Due By]))

Txtcher's avatar
Txtcher
Helper V
1 year ago

I have reviewed the measures created so far and NONE of them work except for the first one: Cases Sent and all that one does is count the rows without any filters.  All of the other measures do not work . Some of them get the first count correct, but the next month's count is completely wrong which is mind boggling. And this measure doesn't even get the first count correct:

Cases Closed:=CALCULATE(
COUNTROWS(
FILTER('RS Cases',
'RS Cases'[Entrance Date]>=Min(Date_Table[Date]) &&
'RS Cases'[Entrance Date]<=Max(Date_Table[Date])

)
)
)

 

Can anyone please help?