切片器使用的数据集:Dep
![](https://img-blog.csdnimg.cn/img_convert/30d1022d1bb55b0a025b8288cf3eaa16.png)
获取多选的值,并显示到卡片图上:
![](https://img-blog.csdnimg.cn/img_convert/853dd449e44bee2faccc33b32e1b7776.png)
使用选中的值去计算Staff表的员工数:
No. of Staff =
VAR fDepartmentName = SELECTCOLUMNS('Dep',"DepartmentName",'Dep'[Department])
RETURN COUNTROWS(
FILTER(
ALL('Staff'),
CONTAINSROW(fDepartmentName,'Staff'[Department])
)
)