Forum Discussion
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...
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.
Anonymous
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.