Forum Discussion

Bfdc's avatar
Bfdc
Frequent Visitor
4 years ago
Solved

Score depending on answer

Hi All, Let's try to make myself understood I've got a list of 7 Risks associated to a consequence parameter. Each Risk is likely to happen from 1 to 5 - Depneding of the user's input ...
Need Help
  • rohit_singh's avatar
    rohit_singh
    4 years ago

    Hi Bfdc ,

    Please try this :

    1) Create two tables and load them into report view

    Table 1 : Risk 


    Table 2: Likelihood

     

    2) Put the likelihood column into a slicer and the risk columns into a table visual.

    3) Create a measure named "Score" as shown below 

     

    Score =

    var _sel = SELECTEDVALUE(Likelihood[Likelihood])

    var _score =

    SUMX(risk,
    Risk[Consequence] * _sel
    )

    Return
    _score

    For any value of likelihood selected, it will show you scores for all risk no.s

    Kind regards,

    Rohit


    Please mark this answer as the solution if it resolves your issue.
    Appreciate your kudos! 🙂

     

rohit_singh's avatar
rohit_singh
Icon for Solution Sage rankSolution Sage
4 years ago

Hi Bfdc ,

Please try this :

1) Create two tables and load them into report view

Table 1 : Risk 


Table 2: Likelihood

 

2) Put the likelihood column into a slicer and the risk columns into a table visual.

3) Create a measure named "Score" as shown below 

 

Score =

var _sel = SELECTEDVALUE(Likelihood[Likelihood])

var _score =

SUMX(risk,
Risk[Consequence] * _sel
)

Return
_score

For any value of likelihood selected, it will show you scores for all risk no.s

Kind regards,

Rohit


Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂