topic Re: Dynamic Group Filtering in DAX Commands and Tips

Dynamic Group Filtering

RobX — Fri, 15 Jan 2021 14:05:55 GMT

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.

Re: Dynamic Group Filtering

Fowmy — Fri, 15 Jan 2021 14:34:11 GMT

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

Re: Dynamic Group Filtering

RobX — Fri, 15 Jan 2021 15:32:00 GMT

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 ) )