Matrix Table - Don't Summarize Text Values

[Anonymous]

Hello,

I have multiple rows in a matrix table - Business Category, Business Sub-Category & Business Name. Some of my values are text, and are only relevant against the last row(s) -Business Name (E.g. the business phone number).

I can currently show ‘First’ as the value summary which works fine against the last row(s) however the summary against the Business Category & Sub-Category ruins the Matrix.

Is there a DAX work-around/measure which only shows these text values on the last rows, and doesn’t summarise these text values?

Please note I have reviewed a few other questions on this community but they’re either subtly different or not really answered. I really appreciate any insights from someone in the know!

Many thanks

[v-janeyg-msft]

Hi, @Anonymous 

It’s not very clear based on the text. Can you provide some sample data and your desired result? So we can help you change the data displayed in the matrix hierarchy.

Best Regards,

Community Support Team _ Janey

[parry2k]

@Anonymous you should use ISINSCOPE function in your measure, read it here. 

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

@parry2k . Thanks for your reply, it's much appreciated. From looking at the function does this not just apply to where values are missing accross the board? My table has a value for every line item, however it is not relevent to summarise them in the category & Sub Category rows in the matrix (I can't think of a situation where anyone would want to summarise text values in a matrix with multiple rows?). Thanks anyway.