Forum Discussion

nino2469's avatar
nino2469
Frequent Visitor
4 years ago
Solved

Measure for a Visual Card

I am trying to create a measure to do the following. When selecting a name in the slicer, I would like for the card to display the Rating for the competency that I filter for that card.   Example: ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    You've just changed the paradigm.  With so many questions, the nested IF will not be a good approach.  It will be better to create a 2 column table and and fetch data from that table into your table with the RELATED() or LOOKUPVALUE() function.

nino2469's avatar
nino2469
Frequent Visitor
4 years ago

I opened the old file from my downloads folder. Let me study this one. Thank you and I will let you know if I have questions.

nino2469's avatar
nino2469
Frequent Visitor
4 years ago

Hi Ashish,

I reviewed this over the weekend and tried to follow as best I could with my limited knowledge. I tried to recreate this in my own dataset but it seems to not pull the info like yours did. I get (blank) on some of my criteria and then everything is not showing in the status list.

 

For reference this is what my ratings code looks like

 

Status 1 = if('Sheet1'[Attribute]<="Q2","Relationship",if('Sheet1'[Attribute]<="Q4","Communication",if('Sheet1'[Attribute]<="Q6","Influence", if('Sheet1'[Attribute]<="Q8","Decison Making", IF(Sheet1[Attribute]<="q10", "Analytic Ability", IF(Sheet1[Attribute]<="q12", "Risk Management", IF(Sheet1[Attribute]<="q14", "Teamwork", IF(Sheet1[Attribute]<="q16", "Leading and Supervising", IF(Sheet1[Attribute]<="q18", "Achieving Personal Goals and Objectives", IF(Sheet1[Attribute]<="q20", "Business Results Orientation", IF(Sheet1[Attribute]<="q22", "Learning and Researching",IF(Sheet1[Attribute]<"q24","Adapting and Responding to Change","Organizational Awareness"))))))))))))
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    You've just changed the paradigm.  With so many questions, the nested IF will not be a good approach.  It will be better to create a 2 column table and and fetch data from that table into your table with the RELATED() or LOOKUPVALUE() function.

    • nino2469's avatar
      nino2469
      Frequent Visitor
      4 years ago

      Hi Ashish,

      I appreciate your responses. I didn't understand what you were saying at first but after reading a few articles on lookupvalue, I have it working. I was also able to use that to color the cells as I needed. I am in the process of testing the data to be sure, but it looks like that is the solution. 

       

      I appreciate the help! I may reply here with some additional questions when I am looking to analyze the data for a group.