Forum Discussion

eaj's avatar
eaj
Helper I
2 years ago
Solved

Creating a Report Page with Department Comparison Using a Slider

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.

 

 

 

Need Help
  • raji_n's avatar
    raji_n
    2 years ago

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

     

4 Replies

  • raji_n's avatar
    raji_n
    Resolver II
    2 years ago

    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's avatar
      eaj
      Helper I
      2 years ago

      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's avatar
        raji_n
        Resolver II
        2 years ago

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