Forum Discussion

DerhakRon's avatar
DerhakRon
Frequent Visitor
2 years ago

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

  • 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