Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Create Calculated Table With Filters applied from Slicers

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])

)

 

 

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago

    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.