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 sy...
Need Help
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.