Remove elements from View that is selected in the Slicer

Hello, In my report page, I have couple of views that shows relation between Countries and other values and different Slicers including one for the Country. The country slicer updates al lvi...

Need Help

v-yalanwu-msft

5 years ago

Hi, Anonymous ;

In my case , we could change the measure as follows:

Inverse Selector = 
IF(NOT(ISFILTERED(Slicer[Country])),1,IF(MAX([Country])  IN DISTINCT('Slicer'[Country]),0,1))

The final output is shown below:

In your case, you could try :

Inverse Selector =
VAR __CurrentCountry =
    MAX ( Merged_VOL_OMD[OMD.MAIN COUNTRY(ENG/BILLING/VENDORS/FINANCIALS)] )
VAR __Countries =
    DISTINCT ( RemoveCountries[Country] )
RETURN
    IF (
        NOT ( ISFILTERED ( Slicer[Country] ) ),1,
        IF ( __CurrentCountry IN __Countries, BLANK (), 1 ))

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Remove elements from View that is selected in.pbix31 KB