Forum Discussion
Score depending on answer
Hi Bfdc ,
Please try this :
1) Create two tables and load them into report view
Table 1 : Risk
Table 2: Likelihood2) Put the likelihood column into a slicer and the risk columns into a table visual.
3) Create a measure named "Score" as shown belowScore =var _sel = SELECTEDVALUE(Likelihood[Likelihood])var _score =SUMX(risk,Risk[Consequence] * _sel)Return_scoreFor 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! 🙂
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
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! 🙂
Thank you so much rohit_singh - I've just learnt few things with that DAX formula!
However, the issue here is that every Risk has a different likelihood, not all them are likely to happen at the same level. So, the end user should be able to say how likely is each of them from 1-5.
I wonder if the easiest thing to do is to create 7 different scores and then 7 tables.