How to remove data from specific levels in Matrix Visual?

[Dkennedy13]

Good Afternoon All,

I am hoping this is a simple question to answer but after spending a ton of time searching the web for answers, it was time to break down and ask the geniuses that visit this site. I have a simple Matrix that breaks down our company's Regions > Managers > Customer Names. One of the data points they want to calculate is the Property Type. (our Customers are Howeowner Associations so can vary from Single Family Homes, to Condos, etc.) This Data point only applies to the Customer level of of the Matrix but since it is in the Value field, it is displaying for Region and Manager as well. How do I remove this so that the data point only shows on the Customer Level? Picture below of the matrix currently so you can see how it is showing. The only options I have since the data is in the Values is "First, Last, Count(Distinct), or Count" I have it listed as First currently since there is only one type assigned to the customer. Any help will be most appreciated. Thank you in advance!! Picture below for visual representation.

[Dkennedy13]

After further digging, i found an article that was asking the same thing i was but worded differently. After trying the solution for that one i determined it was the same as my question. you will need to use something similar to the below measure:

Measure Name = if(ISINSCOPE('QueryName'[column name]),max('QueryName'[valuecolumn]),"-")

So for my example above, i wrote the following:

Property Type = if(ISINSCOPE('Portfolio Details'[AssociationName]),max('Portfolio Details'[Association Type]),"-")

This allowed me to state the only time the property type show was in the Association level since that was now the scope i was looking for. Hope this helps anyone else looking at this post for answers 🙂

Have an amazing day everyone!