Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

create matrix table like below plz help

Hi every one please help me with below scenario.  
data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    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/

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    5 years ago

    Hi, Anonymous 

    Thank you for your feedback.

    Please try the below.