Showing value only at one level of hierarchy

[HxH]

Hi everyone,

I have created a matrix that shows in the rows the customer and related product purchased, and as values the number of products they have purchased So basically I have something like: 
CUSTOMERS       NUMOFPRODUCTS
Customer X                    3

         Product A              1

         Product B              1

         Product C              1  

In my data I have a column with text values that shows the current status of a product. I would like to add this text in the matrix, but only show it at the product level, and not at the customer and total level. I want something like:

CUSTOMERS       NUMOFPRODUCTS      STATUS 
Customer X                    3

         Product A              1                        Delivered

         Product B              1                        Not Delivered

         Product C              1                        Not Delivered

However, if I simply put the column in the values, also the Customer X and Total levels of the matrix are filled. How can I solve this? 

Thanks

[femmegeek]

This is a clever solution. Just what I needed. Thanks!

[HxH · Accepted solution]

I already solved it nevermind. It's a combination of isinscope and hasonevalue! It didn't come to my mind in the first place

Measure =

IF(

ISINSCOPE('Salesforce Data'[Product Name]) && HASONEVALUE('Salesforce Data'[Reason for Stopped]),

VALUES('Salesforce Data'[Reason for Stopped]),

BLANK()

)

I'll offer myself a coffee for the help 

[JNordentoft]

Just had the same issue. It works perfectly - Thanks!