Same stores filter - dynamic column in table?

[alexvc]

Hi there,

I would appreciate any ideas or help on the following case: I have a table with tickets, in which sales are registered with date, amount and the store where the sale was made. This table is related to another one with the store catalog table, with attributes for each store, including opening date. In my report I have filter for dates and I want to include a filter for "same stores" (stores that have been opened by more than 18 months) to be able to compare year over year growth, the catch here is that a "same store" depends on what dates are filtered in the report (minimum date filtered would have to be greater than the store opening date minus 18 months). I was thinking on including a "same store" variable column in the store catalog table, which would change depending on the dates selected by the report, although I don't know if this is possible... any ideas?

Thanks

[v-huizhn-msft]

Hi @alexvc,

For your requirement, it's impossible. Calculate columns/tables are computed during database processing(e.g. data refresh) and then stored in the model, they do not response to user selections on the report. More details, please see the following knowledge base.

Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.

Best Regards,
Angelia

[alexvc]

Thanks for the reply Angelia, do you know any way I could trigger a filter (even at page level) upon a slicer change in the report? I'm basically trying to make a new slicer for "same stores" or "all stores", but this attribute depends on the dates chosen in a date slicer

Thanks

Alex

[Anonymous]

Hi Alex,

Have you found a solution to this problem. I'm facing the same issue

[v-huizhn-msft]

Hi @alexvc,

Here is a case, the report changes dynamically according to the choice in slicer, please review it and check if it is useful.

Best Regards,
Angelia

[v-huizhn-msft]

Hi @alexvc,

Have your resolved your issue? If you have not, please post some sample data for further analysis. So that I can post solution which is close to your requirement. If you have, please mark the helpful reply as answer, or welcome to share your solution. Thanks for understanding.

Thanks,
Angelia