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...
Here's my sample data: Sample Data
I have a measure to get the average score which is:
DIVIDE(SUM('Assessment Scores'[Rating]), SUM('Assessment Scores'[Possible Score]))
I also have a measure that calculates the weighted score based on the what-if parameter:
'Assessment Scores'[Score divided by Possible] * 'Weight'[Weight Value]
As a reminder, I'd like to be able to apply a weight to each category & building independently within the matrix. Thanks!