Create Custom Group By Filter for Different Scenarios

Hi, romoguy15 

You can try the following methods.

Measure:

Measure =
IF (
    SELECTEDVALUE ( 'Table'[Code] ) = "BNG",
    1,
    IF (
        SELECTEDVALUE ( 'Table'[Code] ) = "CBT",
        1,
        IF ( SELECTEDVALUE ( 'Table'[Code] ) = "DBP", 1, 0 )
    )
)

Place this Measure in the Code slicer's view and set it to equal 1.

In this slicer, not selecting any of them is All Codes. Hold down CTRL to select BNG and CBT, or BNG, CBT and DBP. You can achieve one slicer to filter three cases.

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.