Forum Discussion
How to filter table using preselected slicer text value
but still couldnt create the filtered table from the initial 'dummy'. perhaps you have any better idea on that?
In general it is technically not possible to interact with the slicer and change values in the underlying dataset table (in this case filter for a single country). You can do that with Power Query parameter, but users will not have access to it from the report level, see more here:
https://community.powerbi.com/t5/Desktop/Passing-Slicer-Selection-to-Query/td-p/1136501
Why do you need subset of dummy as a materialized table? Formula engine can materialize it on the fly if it's used in a measure, e.g. inside CALCULATE, but duplicating the subset based on a slicer is not gonna work.
HI Stachu
Thanks for the reply. yes, seems the variable that i expect to link user input from the slicer is not working here.
So far the 'Table' is filtered correctly when i key-in the country code:
CALCULATETABLE(dummy,FILTER(ALL(dummy),dummy[country]=="MY"))
Talking about the join, i think i got your idea to create a relationship. this is working as it can narrow down the data in visual based upon user selected country. but still couldnt create the filtered table from the initial 'dummy'. perhaps you have any better idea on that?
filtered table using join relationship
Attached the file.
filtered_table.pbix
Thank a lot.
Cheers 🍻
Community Championbut still couldnt create the filtered table from the initial 'dummy'. perhaps you have any better idea on that?
In general it is technically not possible to interact with the slicer and change values in the underlying dataset table (in this case filter for a single country). You can do that with Power Query parameter, but users will not have access to it from the report level, see more here:
https://community.powerbi.com/t5/Desktop/Passing-Slicer-Selection-to-Query/td-p/1136501
Why do you need subset of dummy as a materialized table? Formula engine can materialize it on the fly if it's used in a measure, e.g. inside CALCULATE, but duplicating the subset based on a slicer is not gonna work.