Forum Discussion
Create a filtered calculated table based on slicer value
Hello, I am trying to create a calculated table based on a data table loaded in power bi. Can someone please help me fix the below dax, I am trying to replace the hard coded "ABC", with a dyn...
Hello anwarbi
build a table based on a slicer selection makes no sense to me. As the table will get refresh only when data is refreshed and not when a user change the selection in the slicer.
Instead if you need to use it on the fly, to make some calculation that can be OK.
To get the value selected from the user you need to use SELECTEDVALUE ('table'[column])
Hope I made my point
Thanks for your response.
The reason I want to create a filtered table based on the slicer value is that then I need to use the filtered data as a vlook up source in another data table.
I have tried using SELECTEDVALUE ('table'[column]), but this does not yield any result as the table is blank.