Create Calculated Table With Filters applied from Slicers

[Anonymous]

Hi, 

I am doing Direct Query report and trying to build a table. Is it possible to pass the slicer value to the summarize column table with selectedvalue ? Thanks 

VAR SelectedStore = SelectedValue (StoreTable[Name])

NewTable = 

SummarizeColumns ( Table1[Column1], 

                                    Table1[Column2],

                                    Table1[Column10]),

             FILTER (Table1, Table1[Column5] = SelectedStore,

             "SumSales" = Sum(Table1[Sales])

)

[V-lianl-msft]

Hi @Anonymous ,

The calculated table cannot be dynamic.

Perhaps you can use the if statement to create a measure to add filter conditions to the visual level filter.

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

[amitchandak]

@Anonymous , You can pass. but Table can not become dynamic if you change the value after that. Only table in measure Var is dynamic and will respond to slicer value