How to never show a value at the top level of a matrix

[possible-possum]

Hi,

I have a Matrix with Project Number nested under Company Name in the rows. The matrix is looking at project profitabilty and overall company profitabilty - we want to see profit by company and have the abilty to drill down by project.

My issue is some clutter with some of the values at the top level. Most companies have 2-8 projects, but some only have 1. I want to hide all of the unsummerised project data (project name, project manager) at the top level of the matrix. Using SELECTEDVALUE() doesn't quite work as in some of the cases, even at the top level there is only one value (as there is only one project) so I end up with a mess of some blank and some populated rows.

Does anyone have a solution for this?

[amitchandak · Accepted solution]

@possible-possum , Try using isinscope -https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

IsInScope - Switch measure at different levels: https://youtu.be/kh0gezKICEM

[possible-possum]

Thanks for pointing me in the direction of ISINSCOPE, it ended up being quite simple to implement:

 

Producer =

IF(

    ISINSCOPE(

        'Projects'[Project ID & Name]),

        SELECTEDVALUE('Projects'[Producer Name])

)