Anti Filtering

I'm wanting to use a slicer, but the data that is displayed (In a table) is the data that isn't in the filter selection, rather the results that haven't been included in the filtering.

Need Help

Anonymous
9 years ago
Hi megskilton

Change the following

5. Create a measure called SelectedBrand = Values(BrandSelect[Brand])
as
SelectedBrand = If(HASONEFILTER((BrandSelect[Brand])), Values(Brand[Select]), Blank())

6. Create a measure called ShowYes
ShowYes = IF(Values(yourfacttable[Brand])=[SelectedBrand],"No","Yes")

as
ShowYes = IF(HASONEFILTER((BrandSelect[Brand])),
IF(Values(yourfacttable[Brand])=[SelectedBrand],"No","Yes"),"Yes")

Try it out and let me know if you run into issues.

Cheers

CheenuSing

v-huizhn-msft

Microsoft Employee

9 years ago

Hi megskilton,

There are duplicate Brand value in selectBrand or facttable, right? Could you please share the sample data or screenshot for further analysis?

Best Regards,
Angelia