Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Combine credbility and criticality from different rows for each model

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

MODELTYPEValue
Model A                                    randomdata5
Model A                                    randomdata5
Model Acredbility3
Model Acriticality2
Model Brandomdata3
Model Brandomdata4
Model Bcredbility2
Model Bcriticality1
Model C                       randomdata4
Model Crandomdata3
Model Ccredbility2
Model Ccriticality4


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 

ModelCredbilityCriticality
Model A32
Model B21

 

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!
 

 

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

Hi @Anonymous ,

 

Try to create measure formula like below:

Measure =
IF ( MAX ( 'Table'[TYPE] ) <> "randomdata", MAX ( 'Table'[Value] ), BLANK () )

vhenrykmstf_0-1669169682943.png

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.

 

View solution in original post

1 REPLY 1
v-henryk-mstf
Community Support
Community Support

Hi @Anonymous ,

 

Try to create measure formula like below:

Measure =
IF ( MAX ( 'Table'[TYPE] ) <> "randomdata", MAX ( 'Table'[Value] ), BLANK () )

vhenrykmstf_0-1669169682943.png

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.

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.