Forum Discussion
What-if Function in a Matrix
Hello! What I have is a matrix of data (below), and I need to assign a dynamic weight (via the what-if function for users) and make it changeable according to each category of a matrix and multi...
Hi lbudack ,
The following link provides a classic example on how you can use what-if parameters in your calculations.
https://radacad.com/power-bi-what-if-parameters
Let me know if this helps.
Thanks,
Pragati
Thanks, but I've already tried the standard what-if parameter. I know how to use those. I can only get it to calculate one value against the first column. I need different variables per category that add up to 100% per building.
Sure. What other data do you need? Is the example at the top not sufficient?
For example, I need each building section to look somewhat like this:
Category Score Weight (from what-if) Weighted Score EQUIPMENT & FURNISHINGS 68.75% 10% 6.9% INTERIORS 72.39% 20% 14.5% SERVICES 68.23% 35% 23.9% SHELL 79.17% 20% 16.8% SITEWORK 40.73% 15% 6.1% I need the "weight" to come from a what-if function to calculate the "weighted score". How do I get it to change per building and per category?
