Forum Discussion

hlg551's avatar
hlg551
Regular Visitor
5 years ago

Displaying a text column in a measure/matrix

Hello,   I have a measure I am using in a matrix as kind of a summary for multiple companies. I am using switch for the column headers and then I have multiple different CALCULATION functions for d...
Matrix Visual
Measures
Text
Anonymous's avatar
Anonymous
Not applicable
5 years ago

hlg551 

Can you explain with example. I cannot fully understand your situation. Maybe provide a sample table and expected output.

 

Paul Zheng _ Community Support Team

  • hlg551's avatar
    hlg551
    Regular Visitor
    5 years ago

    Anonymous 

    Yes, I'll try to explain this better. I have a matrix where I am showing information about various companies. The companies are in the rows and the columns is a SWITCH sentence where I calculate various things I want to show. What I am having problem with is displaying the category of each company. I need to find a function that allows me to display a string in a measure, similar to SELECTEDVALUE but I don't want to have to filter for a specific category I want to show all of them at the same time.

    I tried to create a sample for what I am trying to do.
    This is what I want it to look like:

    This is my measure:

    My tables are connected through IDs:

     

    So I want to display the Category name for every company in my matrix. 

     

    I hope this explains it better, any help would be appriciated 🙂