filter by intersection of filters for another column

[goalie_]

When filtering for a column 1 by column 2, can you find the intersection of the selected elements(in col 2) to get items for col 1 rather than the union? i.e. (see image)

[v-jayw-msft · Accepted solution]

Hi @goalie_ ,

Create an independent slicer table.

slicer = DISTINCT('Table'[var])

Then create the measures.

_flag = IF(SELECTEDVALUE('Table'[var]) in VALUES(slicer[var]),1,0)

_countf = CALCULATE(DISTINCTCOUNT('Table'[var]),FILTER(ALLSELECTED('Table'),'Table'[req]=SELECTEDVALUE('Table'[req])&&[_flag]=1))

Measure = IF([_countf] = COUNT(slicer[var]),1,0)

Add the [measure] to visual filter set value =1.

Result:

Best Regards,

Jay

[amitchandak]

@goalie_ , try to use below measure with req in visual

measure =
var _cnt = calculate(distinctCOUNT(Table[var]), allselected())
return
countrows(filter(summarize(table, table[req], "_1", distinctCOUNT(Table[var])), [_1] = _cnt))