Matrix

[wwenw1]

In a Power BI matrix visual, how can I keep the values hidden or blank at higher (collapsed) levels, so that values only appear when a user expands a row to see the lower-level details? When I use ISINCOPE(), it seems to interfere with the model relationships.

[v-tejrama · Accepted solution]

Hi @wwenw1,

Thanks for reaching out to the Microsoft fabric community forum.

To show values in a Power BI matrix only when a user expands to a lower-level detail, you can use the ISINSCOPE() function inside a measure to dynamically control visibility.

If your hierarchy is Category → Subcategory → Product, and you want values to appear only at the Product level.

Here is the DAX : Visible Sales

IF (
ISINSCOPE(SalesData[Product]),
SUM(SalesData[Sales]),
BLANK()
)

Use this measure in the matrix’s Values field instead of the raw sales column. This will ensure that higher levels (Category and Subcategory) show blank values when collapsed, and only show data when the user drills down to Product.

If you instead want values to be shown at both the Subcategory and Product levels, you can modify the measure like this:

Here is the DAX : Visible Sales Alt

IF (
ISINSCOPE(SalesData[Subcategory]) || ISINSCOPE(SalesData[Product]),
SUM(SalesData[Sales]),
BLANK()
)

Please find the attached pbix file for your reference.

If the response has addressed your query, please "Accept it as a solution" and give a 'Kudos' so other members can easily find it.

Best Regards,
Tejaswi.
Community Support

[v-tejrama]

Hi @wwenw1,

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

If the response answered your query, kindly “Accept as Solution” and Give “Kudos” to help others in the community benefit from it as well.

Thank you.

Tejaswi.

[v-tejrama]

Hi @wwenw1 ,

I hope the information provided has been useful. Please let me know if you need further clarification or would like to continue the discussion.

If your question has been answered, please “Accept as Solution” and Give “Kudos” so others with similar issues can easily find the resolution.

Thank you.

Tejaswi

[v-tejrama]

Hi @wwenw1,

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

If the response answered your query, kindly “Accept as Solution” and Give “Kudos” to help others in the community benefit from it as well.

Thank you.

Tejaswi

[collinq]

Hi @wwenw1 ,

You might be able to just put the matrix at the level that you want and then hide the controls (change the font color and visiblity).  This is a total workaround but something I have done in the past in this situation.

[Elena_Kalina]

Hi @wwenw1 

If ISINSCOPE() is causing issues with relationships:

1. Make sure your model relationships are correctly configured.

2. Check for circular dependencies (where a measure or calculation refers back to itself in a loop).

3. Try using TREATAS() to preserve the correct relationship context.

4. Consider storing intermediate calculations in variables (using VAR) to simplify logic.

For your needs, you could also try using PATH functions (useful for parent-child hierarchies).

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.