Forum Discussion

lbudack's avatar
lbudack
Advocate III
6 years ago

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...
Need Help
lbudack's avatar
lbudack
Advocate III
6 years ago

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. 

Pragati11's avatar
Pragati11
Super User
6 years ago

HI lbudack ,

 

Can you share some sample data?

 

Thanks,

Pragati

  • lbudack's avatar
    lbudack
    Advocate III
    6 years ago

    Pragati11 

     

    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: 

     

    CategoryScoreWeight (from what-if)Weighted Score
    EQUIPMENT & FURNISHINGS68.75%10%6.9%
    INTERIORS72.39%20%14.5%
    SERVICES68.23%35%23.9%
    SHELL79.17%20%16.8%
    SITEWORK40.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? 

  • lbudack's avatar
    lbudack
    Advocate III
    6 years ago

    Pragati11 

     

    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!