Forum Discussion

romoguy15's avatar
romoguy15
Icon for Helper IV rankHelper IV
4 years ago
Solved

Create Custom Group By Filter for Different Scenarios

Hello, I have a list of codes in a column. I am trying to group this list of codes into three different groups. The problem I am running into is the groups each all contain the same values but slight...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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.

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

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.

romoguy15's avatar
romoguy15
Icon for Helper IV rankHelper IV
4 years ago

I think this is a good workaround to achieve. For some reason, bringing the filter into the real data, it just doesn't filter the table because there are calculation sums in the table that won't change with the filter. I believe that is because the calculations are sums but have filters within those sums.