Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
@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.
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.
@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
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 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
5 | |
4 | |
3 | |
3 |
User | Count |
---|---|
14 | |
9 | |
7 | |
3 | |
3 |