Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Filter values at aggregation level

Hi,

 

I have report with 3 grids displaying sum of users vs device, browser and operating system as shown below. I have to add a user slicer to this page where the devices, browser and operating system can be filtered out.

When I add a slicer and select > 220,000 the results are wrongly displayed. I want only "Other" to be filtereed out in 1st grid.

Required results

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , You need a measure like
    Switch ( True() ,

    isinscope(Table[Device]), Sumx(Filter(Values(Table[Device]),[Users] >selectedvalue(Slicer[Value])),[Users]),
    isinscope(Table[browser]), Sumx(Filter(Values(Table[browser]),[Users] >selectedvalue(Slicer[Value])),[Users]),
    // add OTHERS
    )

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      This formula did not work for me its giving wrong values as shown below the original one is on the top and bottom one is with applied measure.

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    The information you provided was not clear enough. Check if amitchandak's formula works for you. Otherwise please provided some sample data and the formula you are using.

     

    Best Regards,

    Jay