create matrix table like below plz help

[Anonymous]

Hi every one please help me with below scenario.

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

I am not sure whether the below is what you are looking for, but please try the below.

Status =

IF (

ISINSCOPE( 'Key Result'[kr_Description] ),

SELECTEDVALUE ( 'Key Result'[Status_ID] ),

SELECTEDVALUE ( Objective[Status_ID] )

)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[Anonymous]

Hi Jihwan Kim,

is there any possibility to eliminate total in the matrix,i.e in your image total is 2. so can we eliminate that?

[Jihwan_Kim]

Hi, @Anonymous 

Thank you for your feedback.

Please try the below.

[Anonymous]

Hi Jihwan Kim,

thanks alot.your measure is working fine in my real time data.