Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
slyfox
Helper II
Helper II

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

I have been working on a formula for a virtual table, but it doesn't work:
SelectedUsergroups =
FILTER(
ADDCOLUMNS(
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:

slyfox_0-1677706334158.png

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

slyfox_1-1677706416045.png

 

3 REPLIES 3
johnyip
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 !!
amitchandak
Super User
Super User

@slyfox , a calculated table can not take slicer value

@amitchandak  😞 any workaround alternative to my approach?

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.