Forum Discussion
Txtcher
Helper V
Helper VDAX 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...
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]))
TxtcherHelper V
Helper VPosting 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]))