Creating a Report Page with Department Comparison Using a Slider

[eaj]

I'm working on setting up a report page where users can select specific departments to compare against the rest. The idea is to use a slicer to pick certain departments, which would then be grouped into "Group 1," while all other departments automatically fall into "Group 2."

I tried setting this up, and I’ve attached a picture showing my current setup. Unfortunately, it doesn’t work as intended. Specifically, I’m struggling with how to make the non selected departments go into Group 2.

[raji_n]

I have created two tables

Measure1 = IF(ISFILTERED('Table (2)'[Column1]),IF(MAX('Table'[Column1]) in ALLSELECTED('Table (2)'[Column1]),1,0))

Measure =

IF([Measure1]=1,"GR1","GR2")

This is my outcome where whichever value is selected is shown as GR1, others GR2

@eaj 

[eaj]

Thanks, this might be my lack of experience talking, but if it is a measure, how do I get lets say total revenue for group 1 and 2. I can't filter on measures, right?

 Doesn't it have to be some calculated column in my main department table?

[raji_n · Accepted solution]

@eaj you can use a measure to return the values instead of 1 or 0 and get the totals

[eaj]

That is very clever, didn't think of that. Thanks!