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,

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

  • 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.