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! 🙂
Solution SageHi 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.- rohit_singh
Hi Bfdc ,
No worries. I wonder if this solution works for you :
Modify your table likelihood to include a column for Risk. Each risk value will have different levels of likelihood as shown.
Create a relationship between the new likelihood table and the risk table.
Use the likelihood column from the new table as the slicer.You will see all risk values that have the selected likelihood.
I don't know how much this will help, but you can think of modifying your table schemas slightly to fit your requirements.
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
