Measure for a Visual Card

[nino2469]

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: If I select Sue one card will display the rating for the competency for relationships, the next card will display the rating for communication, and so on. 

My data is built in two tables. One is the survey data and the other is a score table to create the ratings based on scores.

I have linked an example file here. Please let me know if this makes sense.

Assessment Dashboard 

[Ashish_Mathur]

Hi,

This is a cleaner model to work with.  Please study this carefully and let me know how this works.  I have not worked on the colouring so far.

[nino2469]

Hi Ashish,

If you look at the newer file I uploaded you can see that I was able to get the coloring working based on the competency. If I drop that into a table it all works. I am now trying to use the Card visual to display competency and rating based on the Name selected. 

If I select Sue I want one Card to display the rating for the relationship, another card to display the rating for communication. Does that make sense? When I try to pull the rating to the card it is just giving me first rating.

[Ashish_Mathur]

With Bob and Communication selected, my file shows the correct answer.

[nino2469]

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]

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 · Accepted solution]

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]

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.