ALLSELECTED leaving one category out when summarizing

[Anonymous]

Measure = CALCULATE([FTE],ALLSELECTED(AllEmp[Grades]))

Grades is a calculated column.

what could be the reason the filter on "S" grade is not lifted by ALLSELECTED? thanks.

[v-xuding-msft]

Hi @Anonymous ,

I can’t reproduce your issue. Is the calculated column of Grades from two or more tables? And what is the measure of FTE? Can you please share more details and the sample data?  Then we can help you as soon as possible.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.