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 table visual with an output that has both/all of the selected slicer values that looks like this:
but it displays the selected values in an OR logic instead of showing only values that have both/all of the selected slicer values:
the last row should not be included since it only has the B item.
2 Replies
- amitchandak
Super User
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])
