Forum Discussion

Helper I

8 years ago

Solved

Exclude vs All Slicer

Admittedly this is a very simplified view of the data set but ultimately what I want to do is create a slicer that either includes Federal in the visuals or does not. Order_ID Industry Amoun...

Need Help

v-yuta-msft

8 years ago

Hi shep123,

You can create a Flag table which has only one column containing two values "Federal" and "NonFederal", then create a measure using DAX below:

Count = 
IF (
    SELECTEDVALUE ( Flag[Flag] ) = "Federal",
    CALCULATE ( COUNT ( Table1[Order_ID] ), ALLEXCEPT ( Table1, Table1[Industry] ) ),
    IF (
        SELECTEDVALUE ( Flag[Flag] ) = "NoneFederal",
        IF (
            MAX ( Table1[Industry] ) <> "Federal",
            CALCULATE ( COUNT ( Table1[Order_ID] ), ALLEXCEPT ( Table1, Table1[Industry] ) ),
            BLANK ()
        )
    )
)

PBIX here: https://www.dropbox.com/s/iqicxwd1ucu1zaq/Exclude%20vs%20All%20Slicer.pbix?dl=0

Regards,

Jimmy Tao

v-yuta-msft

Community Support

8 years ago

Hi shep123,

You can create a Flag table which has only one column containing two values "Federal" and "NonFederal", then create a measure using DAX below:

Count = 
IF (
    SELECTEDVALUE ( Flag[Flag] ) = "Federal",
    CALCULATE ( COUNT ( Table1[Order_ID] ), ALLEXCEPT ( Table1, Table1[Industry] ) ),
    IF (
        SELECTEDVALUE ( Flag[Flag] ) = "NoneFederal",
        IF (
            MAX ( Table1[Industry] ) <> "Federal",
            CALCULATE ( COUNT ( Table1[Order_ID] ), ALLEXCEPT ( Table1, Table1[Industry] ) ),
            BLANK ()
        )
    )
)

PBIX here: https://www.dropbox.com/s/iqicxwd1ucu1zaq/Exclude%20vs%20All%20Slicer.pbix?dl=0

Regards,

Jimmy Tao