Forum Discussion

DemingPDCA's avatar
DemingPDCA
Helper II
1 year ago

Select Month and see multiple date relationships

I have a report that seems to work great as far as the actual Counts I want - but I'd like to be able to select the month and see ALL Events that tie to that month (anything  opened, dispositioned or closed). Right now if I select the month - it counts that I have 14 closed which is correct, but it only shows 7 of the ones that were closed this month because the active relationship to the date table in based on occurrence date and those events started in prior months. 

_Opened PEs = CALCULATE(DISTINCTCOUNT('MES PEs'[EventName]), FILTER('MES PEs', 'MES PEs'[EventStatus] <> "Deleted" || 'MES PEs'[EventStatus] <> "Pending"))
_Dispositioned PEs = CALCULATE([_Opened PEs], USERELATIONSHIP(_DMRCalendar[Date], 'MES PEs'[DispositionDate]))

_Closed PEs = CALCULATE(COUNTROWS('MES PEs'), USERELATIONSHIP(_DMRCalendar[Date], 'MES PEs'[CloseDate]))


Is there any good way to do this?
Need Help

3 Replies

  • parry2k's avatar
    parry2k
    Super User
    1 year ago

    DemingPDCA cross filter direction on the relationship should be single not both. Change the relationship cross filter direction and it should work.

  • parry2k's avatar
    parry2k
    Super User
    1 year ago

    DemingPDCA not sure why, It will be easier if you share pbix file using one drive/google drive with the expected output. Remove any sensitive information before sharing.