Filter values at aggregation level

[Anonymous]

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

[Anonymous]

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

[amitchandak]

@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]

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.