This should be a simple task. But I struggled with it longer than I really should have.
Goal
Count unique number of FTEs only when the flag FTE is 1.
It turned out that all I need to do is to put the IIF function inside the COUNTDISITNCT function.
CountDistinct(IIF(Fields!FTE.Value = 1, Fields!UW_NM.Value,Nothing))
But I started in the wrong direction. I put the CountDistinct function inside the IIF function.
IIF(Fields!FTE.Value = 1, CountDistinct(Fields!UW_NM.Value), Nothing)
Tags: SSRS EXPERT,