Forum Discussion
How to Combine multiple measures in a single matrix
I have 4 different measures that are calculating SUM of columns of different tables. And i wanted to display them in a matrix.
Is there a any way to display these 4 different measures in a single line in a matrix? The first screenshot below is how it looks like when i try to display them.
Can you please help on this ...
Screenshot 1:
I need to display 4 measures into single Valu. like below format:
Try COALESCE to return the first non-blank value.
COALESCE ( [Val], [Val1], [Val2], [Val3] )
2 Replies
- AlexisOlson
Super User
Try COALESCE to return the first non-blank value.
COALESCE ( [Val], [Val1], [Val2], [Val3] )AlexisOlson Thank you so much...Its working...