Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Counting same event with two dates using same Dim Date and USERELATIONSHIP

Hello,   I need to retrive the number of Due events for month/year, retrieve also the number of events done on the same month/year.  In my dataset I have two tables 1) Maintenance_Jobs_Archive 2...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    8 years ago

    Just to let you know that did find the issue.

     

    The solution is not using the "Filter" function from the measure. 

     

    # Done Jobs (Archive) = CALCULATE(COUNT(VW_MAINTENANCE_JOBS_ARCHIVE[Job ID]), USERELATIONSHIP(VW_MAINTENANCE_JOBS_ARCHIVE[Done Date], 'T_BASS_DIM_DATE (Jobs)'[Date]))

     

    # Due Jobs (Archive) = CALCULATE(COUNT(VW_MAINTENANCE_JOBS_ARCHIVE[Job ID]), USERELATIONSHIP(VW_MAINTENANCE_JOBS_ARCHIVE[Due Date], 'T_BASS_DIM_DATE (Jobs)'[Date]))

     

    So if  you use USERELATIONSHIP, dont user "Filter"

     

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Just to let you know that did find the issue.

 

The solution is not using the "Filter" function from the measure. 

 

# Done Jobs (Archive) = CALCULATE(COUNT(VW_MAINTENANCE_JOBS_ARCHIVE[Job ID]), USERELATIONSHIP(VW_MAINTENANCE_JOBS_ARCHIVE[Done Date], 'T_BASS_DIM_DATE (Jobs)'[Date]))

 

# Due Jobs (Archive) = CALCULATE(COUNT(VW_MAINTENANCE_JOBS_ARCHIVE[Job ID]), USERELATIONSHIP(VW_MAINTENANCE_JOBS_ARCHIVE[Due Date], 'T_BASS_DIM_DATE (Jobs)'[Date]))

 

So if  you use USERELATIONSHIP, dont user "Filter"