Filter visual by two slicers

[Anonymous]

Hi,

I have two slicers on my report (which are based on the same column in the same table, the column contains only text). I want to use the selection of both of these slicers to filter a visual (more secifically the breakdown of a waterfall chart but I guess that's not relevant here). How could I do that? 

After some research, this is my approach so far:

1.) create two copies of the table - both slicers are based on one of the copies, and the copies have no relationships.

2.) write  two measures:

measure 1 = ALLSELECTED(CopyTable1[mycolumn])    

measure 2 = ALLSELECTED(CopyTable2[mycolumn]) 

3.) that's where I don't know how to proceed. I think I have to somehow combine these two measures and then filter the visual based on this, correct? Or is my approach completely wrong?

Thanks for any hint!

[amitchandak · Accepted solution]

@Anonymous , refer my example to dates, how two independent tables have been used for filter . Here you have to use in clause

calculate(countrows(Table) , filter(table, Table[mycolumn] in ALLSELECTED(CopyTable1[mycolumn]) ))

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601