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.

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.