Forum Discussion
Solved
Filters used with Matrix Help
Could Someone help me with this challenge? When setting the slicer to two of the selections ( BI developer and Data engineer ) I am still getting person 1014 as part of the table when this person ha...
Hi DavidAllen ,
Here are the steps you can follow：
1. Create measure.
Total Skills = COUNT('Table'[Skill])Count_Measure = CALCULATE(DISTINCTCOUNT('Table'[Skill]),ALLSELECTED('Table'))Flag = var _count=COUNTX(FILTER(ALLSELECTED('Table'),[Person ID]=MAX('Table'[Person ID])),[Skill]) return iF(_count =[Count_Measure],1,0)2. Place [Flag] in Filters, set is=1, apply filter.
3. Result:
After selection, 1014 is filtered out
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
DavidAllen , Try a measure like
measure =
var _cnt = countx(allselected(Fact_personalSkill), Fact_personalSkill[Skill])
return
sumx(filter(summarize(Fact_personalSkill, dim_person[person id], "_1", [Total Skills]), [_1] =_cnt) ,[_1])