cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hlg551
Regular Visitor

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 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 🙂 

4 REPLIES 4
V-pazhen-msft
Community Support
Community Support

@hlg551 

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.

V-pazhen-msft_0-1620698065373.png

 


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

 

@V-pazhen-msft 
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.  

V-pazhen-msft
Community Support
Community Support

@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

@V-pazhen-msft 

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:

hlg551_0-1620652637285.png

This is my measure:

hlg551_1-1620652700610.png

My tables are connected through IDs:

hlg551_2-1620652755430.png

 

hlg551_4-1620652778561.png

hlg551_5-1620652789764.png

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

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

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.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.