Hello,
I put together a proof of concept dashboard that takes into account numerous user inputs. THe functionality works great, however the performance is terrible. My Tables take a long time to refresh with the user input data (what-if parameters).
Revenue_User_Input =
IFERROR(
SUMX(
DISTINCT('New Allocation'[Product]),
SWITCH([Product],
"Product1", ([Revenue] * [% Product1 Allocation Value]),
"Product2", ([Revenue] * [% Product2 Allocation Value]),
"Product3", ([Revenue] * [% Product3 Allocation Value]),
"Product4", ([Revenue] * [% Product4 Allocation Value]),
"Product5", ([Revenue] * [% Product5 Allocation Value]),
"Product6", ([Revenue] * [% Product6 Allocation Value])
)),0)
New Allocation[Product] is a measure that refers to the calculated table I used to pull the specific products I needed. I did this so that I could add in a total column (used elsewhere) and an additional product that is not yet in my base data (new product will be launched in the future).
New Allocation = VALUES('Product Reference'[Product])
Product Reference =
UNION(
VALUES('Base Table'[Product]),
ROW("Column1"," Total"),
ROW("Column1","Product6")
)
Have tried a few ways of working around this, but they all have similar performance issues.
Any help is greatly appreciated!
