Dynamic table using selected values from a slicer

[darshiw]

Hello,

Is there a way to create a dynamic table in Power BI using the selected values from a slicer?

If I unpack my question, i need to create a dynamic table which lookups rows from another table and it needs to filter rows by the selected values from a slicer.

Any help will be much appreciated...

Thanks

[CheenuSing]

Hi @darshiw 

Calculated Tables are created only once at the load time and therefore can not create based on the slicer value .

However, if you want to build a measure on dynamic table created based on slicer this has to be done within the measure.

If you can put sample dat / pbix file in OneDrive / Google Drive and sshare the link it will help.

Cheers

CheenuSing

[darshiw]

Hi CheenuSing,

Thanks for the reply.

I have a data table for all the assignments assigned to each employee. Below is a general sample of data.

For example BR1 is assigned for only 2 PSs (PS1 & PS2). 

Also one PS is assigned to several employees. Ex. PS1 is assigned to 4 employees BR1, BR2, BR3 and BR4.

PS ID	ASA ID	Emp ID
PS1	ASA1	BR1
PS1	ASA2	BR2
PS1	ASA3	BR3
PS1	ASA4	BR4
PS2	ASA5	BR5
PS2	ASA6	BR1
PS2	ASA7	BR4
PS3	ASA8	BR2
PS3	ASA9	BR6
PS3	ASA10	BR7

I have slicer to select Emp ID. My requirement is, if the user select BR1, the visual should display the records from this table for all the Plans (PSs) associated with BR1. The result should be like below.

PS ID	ASA ID	Emp ID
PS1	ASA1	BR1
PS1	ASA2	BR2
PS1	ASA3	BR3
PS1	ASA4	BR4
PS2	ASA5	BR5
PS2	ASA6	BR1
PS2	ASA7	BR4

Hope this makes sense.

Thanks