Forum Discussion
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 sy...
amitchandak
Super User
Super UserAnonymous , 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
)
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.