Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have several models, each model has 2 scores: credbility and criticality. I need both to make a risk assessment. the risk assessment is mixed in with random data that i'm not intrested in.
This is how the table looks
MODEL | TYPE | Value |
Model A | randomdata | 5 |
Model A | randomdata | 5 |
Model A | credbility | 3 |
Model A | criticality | 2 |
Model B | randomdata | 3 |
Model B | randomdata | 4 |
Model B | credbility | 2 |
Model B | criticality | 1 |
Model C | randomdata | 4 |
Model C | randomdata | 3 |
Model C | credbility | 2 |
Model C | criticality | 4 |
For each model I want to know the criticality and credbility so I can use it in a 5x5 risk assessment matrix. I have the matrix but i'm new to power bi so I don't know to extract the values for each model. I have looked at group by and conditional columns been searching around yesterday and played around with unpivoting and transpose but there is something i'm not really getting and I would appreciate all the help I could get!
If I could get the values to for example: Model A, 3,2 or maybe a different table with
Model | Credbility | Criticality |
Model A | 3 | 2 |
Model B | 2 | 1 |
That could work perhaps? i'm not sure what to do to get there or what's best.
Thankful for any help that I can get!
Solved! Go to Solution.
Hi @Anonymous ,
Try to create measure formula like below:
Measure =
IF ( MAX ( 'Table'[TYPE] ) <> "randomdata", MAX ( 'Table'[Value] ), BLANK () )
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Try to create measure formula like below:
Measure =
IF ( MAX ( 'Table'[TYPE] ) <> "randomdata", MAX ( 'Table'[Value] ), BLANK () )
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
141 | |
70 | |
69 | |
53 | |
52 |
User | Count |
---|---|
208 | |
94 | |
64 | |
60 | |
57 |