Forum Discussion
AND logic when filtering delimited table values to multiple selection in slicer
I have 2 tables (table 1, table 2) that are connected by an ID column. Model: Basically, I wanted to have multiple selected values from the Item slicer and display them in the tab...
Anonymous , use a measure like
measure =
var _cnt = calculate(distinctcount(Table2[Item]), allselected(Table2))
return
countx(filter(summarize(Table1, Table[ID],"_1" ,distinctcount(Table2[Item])),[_1] >=_cnt),[ID])
The count measure is already working as it only counts the valid records that have all of the selected slicer values, but how do I reflect it on my table to show only these records?
ex. in this scenario, I wanted to reflect only 1 unique record on the table visual as it displays in the measure