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 i...
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

     

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

       

      • eaj's avatar
        eaj
        Helper I
        2 years ago

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