Forum Discussion
DerhakRon
2 years agoFrequent Visitor
Dynamically Create Table with Slicer Value that is Always Selected
I have implemented the suggestion in this post to always have a value always be present based on the slicer selction. Currently, I have this implemented with a manually created table and entering all the appropriate values.
How can I create the 2nd table in that post from the first table in DAX? I would like to have the table dyncamically generated, since there many options involved and it will be hard to manage.
1 Reply
- amitchandakSuper User
DerhakRon , In case you plan to create a table that will use values from filter or slicer, I doubt you can do that.
The table and calculated table are static and will not refresh using slicer values.
Data refresh will change values and the table can use M parameters