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 multiply the average scores below by the weight into a separate column (weighted score). This needs to happen per building. The weights should add up to 100% per building if that helps. Do I maybe need more than one matrix, slicer, or visual? Thanks!
| Building Name | Category | Average Score | Weighted Score |
| Building #1 | EQUIPMENT & FURNISHINGS | 68.75% | |
| INTERIORS | 72.39% | ||
| SERVICES | 68.23% | ||
| SHELL | 79.17% | ||
| SITEWORK | 40.73% | ||
| Building #2 | EQUIPMENT & FURNISHINGS | 62.50% | |
| INTERIORS | 73.28% | ||
| SERVICES | 66.76% | ||
| SHELL | 75.00% | ||
| SITEWORK | 39.15% | ||
| Building #3 | EQUIPMENT & FURNISHINGS | 62.50% | |
| INTERIORS | 71.36% | ||
| SERVICES | 71.09% | ||
| SHELL | 66.67% | ||
| SITEWORK | 45.92% | ||
| Building #4 | EQUIPMENT & FURNISHINGS | 68.75% | |
| INTERIORS | 75.10% | ||
| SERVICES | 71.88% | ||
| SHELL | 70.83% | ||
| SITEWORK | 42.53% |
6 Replies
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.
lbudack
I think Pragati11 meant sample data is the Data table not just the expected matrix.Read this post to describe your sample:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Regards
Paul
