Dynamic Group Filtering

[RobX]

I'm looking to create a slicer filter that works against an aggregated value.

I have the following table where column be in summed in a visual.

And I have a second table with the following groups

If I select 0-5 in the slicer, the visual would filter for only A since the aggregated value is 3.

If I select 11-15, the visual would filter for only C since the aggregated value is 11.

[Fowmy · Accepted solution]

@RobX 

Create a table for the group as follows

Group   mn     mx

0 - 5	0	5
6 - 10	6	10
11 - 15	11	15

Create the following measure and assign it to the visual filter and set it to 1

Group Selected = 

var __groupmn = SELECTEDVALUE(tGroup[mn])
var __groupmx = SELECTEDVALUE(tGroup[mx]) 
var __value = CALCULATE(SUM(T15[Value]))
return
IF( 
    __value >= __groupmn && __value <= __groupmx,
    1,
    0
)

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

[RobX]

Thanks Fowmy.  There was one thing I had to change.  When no group is selected, the value was 0 so the charts wouldn't populate.  I had to update the if statement to 

IF(
    __groupmn = Blank() && __groupmx = Blank(),
    1,
    IF( 
        __value >= __groupmn && __value <= __groupmx,
        1,
        0
    )
)