Forum Discussion
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: 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.
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.
7 Replies
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.
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.
With Bob and Communication selected, my file shows the correct answer.
