Forum Discussion

JPScotland's avatar
JPScotland
Helper I
4 years ago
Solved

Filter not picking up values

I have 3 tables [jobbing_Data_General], [Completed_Jobs], and [Date].    [jobbing_Data_General] is 1:1 with [Completed_Jobs] on attribute [Job Number as integer].  [jobbing_Data_General] is 1:many...
Need Help
Show and Tell
  • johnt75's avatar
    johnt75
    4 years ago

    Not sure if this will work but you can try

    Count of Emergency Jobs Complete = 
                CALCULATE (
                            COUNTROWS (Jobbing_Data_General), 
                            USERELATIONSHIP (
                                                Completed_Jobs[Date Job Completed (Date Only)], 'Date'[Date]
                            ),
                            Jobbing_Data_General[Job Priority Code] = "3"
                )
johnt75's avatar
johnt75
Super User
4 years ago

Not sure if this will work but you can try

Count of Emergency Jobs Complete = 
                CALCULATE (
                            COUNTROWS (Jobbing_Data_General), 
                            USERELATIONSHIP (
                                                Completed_Jobs[Date Job Completed (Date Only)], 'Date'[Date]
                            ),
                            Jobbing_Data_General[Job Priority Code] = "3"
                )
  • JPScotland's avatar
    JPScotland
    Helper I
    4 years ago

    Legend of Zelda.  Thanks 🙂