Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Calculated dynamical table


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 each group.

I have been working on a formula for a virtual table, but it doesn't work:
SelectedUsergroups =
VALUES(D_Usergroups[Usergroup Desc]),
"Selected", IF(ISFILTERED(D_Usergroups[Usergroup Desc]), "Yes", "No")
[Selected] = "Yes" && NOT(ISBLANK(D_Usergroups[Usergroup Desc])) &&
CONTAINS(D_Usergroups, D_Usergroups[Usergroup Desc], D_Usergroups[Usergroup Desc])


Data sample I have:


Slicer was added (with pre selected values as example):



Solution Specialist
Solution Specialist

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


Super User
Super User

@slyfox , a calculated table can not take slicer value

@amitchandak  😞 any workaround alternative to my approach?

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors