Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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):



Super User
Super User

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


Please mark my post as the solution if this answers your question!
Appreciate your Kudos !!
Super User
Super User

@slyfox , a calculated table can not take slicer value

@amitchandak  😞 any workaround alternative to my approach?

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors