Creating a new Table based on Values in Slicer

Hi Anonymous ,

The calculated tables and calculated columns are static. So it is impossible to get data from a slicer dynamically. You could try to create a measure to show the selected values.  Please see the formula below:

Measure =
VAR a =
    ALLSELECTED ( 'Table 1'[name] )
RETURN
    CALCULATE (
        SUM ( 'Table'[requestedamount] ),
        FILTER ( 'Table', 'Table'[name] IN a )
    )

Reference:

https://radacad.com/scenarios-of-using-calculated-tables-in-power-bi

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.