Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Create a Dynamic List/Table Based on Selection/Drillthrough

Hello,   For the sake of simplicity, I have a list of stores and sales (see table below). I would like to be able to select a store (via click, slicer, or preferrably drillthrough) and dynamically ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    You may download my solution file from here. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Mr. Mathur, you are truly a wizard. I learned much from your posted solution and appreciated the extra functionality you added.

 

However, is it possible to produce a table that is filtered based on the [Store_Name]s that are similar to the store selected in the slicer? Your code produces an excellent list of similar stores with the CONCATENATEX function, but is it possible to produce an analogous table to the Data table that is dynamically limited to the stores within the selected range from the selected store?

 

I tried variations on: New Table = FILTER(Data, Data(sales) <= [upper limit] && Data(sales) >= [lower limit])

but I could not change the content of this calculated table with the slicer.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

You are welcome.  Thank you for your kind words.  My objective initially was to produce a Table but i could not do so because in the slicer when we select a Store, the table cross filters and shows the same store.  I tried to turn off edit interctions but could not get much success there either.  This is the best i could come up with.