-
1. Re: How to do distinct count on a measure with max date only?
Try
COUNTD(IF [Data Date] = { FIXED : MAX([Data Date] } THEN [Employee ID] END)
-
2. Re: How to do distinct count on a measure with max date only?
Deepak Rai
Sep 11, 2019 12:13 PM
{COUNT(IF { FIXED : MAX([Data Date] } =Data Date Then Data Date end)}
-
-
4. Re: How to do distinct count on a measure with max date only?
If you want a non-LOD approach:
Only offering in case your dataset is large and the performance is bad.
You could also just drag on the Month onto your filter and have it default to Most Recent Available.
