I am trying to create a measure that counts others whenever user selects a department on the slicer.
I have the following tables:
And then I have another table to show the department count
I have created an index between each of the tables with their ID and BldgCode and used that to create a relationship among the tables. Afterwards, I have tried to use the following measure to show counts of others.
Other Department =
VAR SelectedDept = SELECTEDVALUE(Table2[Department],“Sales”)
Slicer_Others Sample.pbix (31.3 KB)