Forum Discussion
Calculated dynamical table
Hello, How to create a dynamic virtual table that will be updated every time the user changes his selection in the Slicer? The virtual table should contain the selected value in the filter + id of ...
slyfox Maybe you can create calculated table as a exact copy of your original one, and then create some measures to scan what values are selected in the slicer, like the following:
IsSelected = IF(MAX('CalculatedTable'[Usergroup]) in ALLSELECTED('Table'[Usergroup]),1,0)
and then in your table / matrix / bar chart / whatever vis, use the fields in your CALCULATEDTABLE and add [IsSelected]=1 as the visual filter.
Hope you find this helps.