Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Displaying a text column in a measure/matrix



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 displaying what I need.


However I am having trouble displaying a column that is supposed to show the category for the companies. The data is text. I have tried SELECTEDVALUE and that works if I have slicer and pick that specific category but I want to show the matrix for all categories at the same time, any ideas?


Thanks 🙂 

Community Support
Community Support


Since the category table and company are well related. Instead of create a switch measure. You can just use 2 columns with other 2 measures{"sum" and "sum of two things") in a table visual.



Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.


Thank you for your suggestion.

It is only my sample that is so simple, I just created it this way to show what I wanted from the category column, my real measure has a lot more in it so I need to try to keep the SWITCH sentence in.  

Community Support
Community Support


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


Paul Zheng _ Community Support Team


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 🙂 

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates