Change a calculated table based on a selected value?
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.