Forum Discussion

Yolo_pbi's avatar
Yolo_pbi
Frequent Visitor
2 years ago

Inactive relation causing the filter to not work

Hi Guys, Need help with dealing with an inactive relationship below in HR data. Context: I am trying to get the total active employees based on the date slicer from date table and the c...
Need Help
some_bih's avatar
some_bih
Community Champion
2 years ago

Hi Yolo_pbi not enought infos to provide some sound solution. 

Still, try v2

Headcount v2 =

VAR __max_date=MAX('Date'[Date])
RETURN
CALCULATE(
DISTINCTCOUNT(DET[Staff Member]),
FILTER(
DET,
DET[Joined] <= __max_date &&
(
DET[Last Date Worked] > __max_date || ISBLANK(DET[Last Date Worked])
)
)
)