Forum Discussion

Adidas's avatar
Adidas
Icon for Helper I rankHelper I
5 years ago

Calculating a dynamic table based on a slicer selection

Hi all.
I'm trying to calculate a dynamic table with Dax, Based on an existing table with a slicer over it.
The new calculated table should contain only the values left by the slicer.
For example:
This is the original full table1:


choosing these values in slicer should populate a new table with these unique values only:

 

I don't want to use a visual's filter above the calculated table.
I want the Dax to directly calculate only the valid values.
Thanks

1 Reply

  • MattAllington's avatar
    MattAllington
    Icon for Community Champion rankCommunity Champion

    There are 2 types of tables; visual tables in a report and data tables in the model. You cannot use a slicer to influence the creation of a data table in a model.