Hi
I am currently using this formula =CALCULATE(DISTINCTCOUNT('2019 Data'[Line Manager]),ALLEXCEPT('2019 Data','2019 Data'[Sales Leader],'2019 Data'[Next Line Manager]))
to be able to count the number of line managers in the data I'm using. I want to be able to exclude any Line Manager that equals None.
How do I do this
TIA
Bookmarks