Forum Discussion

amy2x23's avatar
amy2x23
Frequent Visitor
10 years ago

Filter out data if on another table

I've got two queries that I've imported from SSAS, one for Quote Names and the other for Opportunity Names.  Both queries show the same Quote Number so I built a third dataset that has unique quote n...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
10 years ago

amy2x23

 

In this scenario, since you have different spell on Names in two tables, you have to filter the table based on Quote Numbers unless you keep unique format on Names. You can add a calculated column for slicer like:

 

Column = IF(Table1[ID]=RELATED(Table2[ID]),"In","Not In")

Then use this column in a slicer. Also create another slicer for Names. When you click "In" or "Not In", the Names slicer will be cascaded. 

 

Regards,