exclude value of distinct count

[YBZ]

Hi,

I would like to create a measure with distinct count that excludes one value out of the Employee Table. However, somehow it anyway includes the value.

Yearly Employee count = calculate(DISTINCTCOUNT('2019-2022'[Employee]),filter('2019-2022',NOT '2019-2022'[Employee] IN {"Not assigned"})

Anybody an idea what is wrong with the formula?

Regards

[amitchandak]

@YBZ , May be an issue with the letter case, try like

Yearly Employee count = calculate(DISTINCTCOUNT('2019-2022'[Employee]),filter('2019-2022', Upper('2019-2022'[Employee]) <> "NOT ASSIGNED"))

[YBZ]

@amitchandak thank you, but unfortunately that did not solve the issue