Change a calculated table based on a selected value?

[Thigs]

Hi all, 

Looking at an interesting puzzle. Basically, we want to create a tiny store model in PBI with several variables that can be changed. The one I am looking at right now is number of aisles. Basically, I want to create a tiny summarize table that would change based on an input/what if slider. 

Here's what the formula looks like (it isn't working) - 

Random Aisle Assignment = summarize(Pareto,Pareto[ITEM_ID],Pareto[Category], "Aisles", RANDBETWEEN(1,SELECTEDVALUE(Aisles[Aisles])))

Aisles is a what-if parameter with any number between 1 - 25. Item ID is the SKU ID, Category is what type of product (food, etc) that I want to ensure is equally distributed around the store. 

Is something like this possible, where the table itsself changes based on an input value that the user - not the designer - could control? I'd like it to be so people can change it without editing any code and just being able to use a slicer to change. 

[Anonymous · Accepted solution]

That is impossible.

Calculated columns and calculated tables are evaluated once when the data is loaded and are static until the data is refreshed.

[Thigs]

Exactly what I needed to know, thanks!