Forum Discussion
Displaying text in a measure/matrix
Hi hlg551 ,
In the category banch of Companyoverview measure, use the following measure:
LOOKUPVALUE(Category[CategoryName],Category[CategoryID],MAX(Companies[CategoryID]))If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
v-deddai1-msft amitchandak
I'll try to explain my problem 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.
My sample example is very simple but my real measure has a lot of information in it so I need to be able to use a matrix, not a table.
I hope this explains it better, any help would be appriciated 🙂
Community SupportHi hlg551 ,
In the category banch of Companyoverview measure, use the following measure:
LOOKUPVALUE(Category[CategoryName],Category[CategoryID],MAX(Companies[CategoryID]))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai