cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

## Showing value only at one level of hierarchy

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

1 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
3 REPLIES 3
Anonymous
Not applicable

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

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
Anonymous
Not applicable

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.