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/

4 Replies

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

        Hi, Anonymous 

        Thank you for your feedback.

        Please try the below.