Change a calculated table based on a selected value?

Thigs — Tue, 07 Jun 2022 19:08:48 GMT

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.

Re: Change a calculated table based on a selected value?

Anonymous — Thu, 09 Jun 2022 10:26:05 GMT

That is impossible.

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

Re: Change a calculated table based on a selected value?

Thigs — Thu, 09 Jun 2022 18:13:43 GMT

Exactly what I needed to know, thanks!

topic Change a calculated table based on a selected value? in DAX Commands and Tips

Change a calculated table based on a selected value?

Re: Change a calculated table based on a selected value?

Re: Change a calculated table based on a selected value?