How to hide specific values in matrix table

[m_roussakis]

Wondering if it's possible to hide specific values once a certain degree of expansion has been reached in matrix table?

 Example:

Value X can be expanded as follows:

Country/State/City/Street

Is it possible to only show Value X up until State? So if user expands past state, all they would see is blank for City and the Street?

Thanks.

[m_roussakis]

Only effect I have noticed is the total is blank on the matrix table for this value. 

[Greg_Deckler]

@m_roussakis Maybe.

Measure =
  SWITCH(TRUE(),
    ISINSCOPE('Table'[Country]) || ISINSCOPE('Table'[State]),[Some measure],
    BLANK()
  )

[m_roussakis]

@Greg_Deckler I tried this out and it still doesn't hide the intended levels in the table ....

[Greg_Deckler · Accepted solution]

@m_roussakis OK, try the reverse:

Measure =
  SWITCH(TRUE(),
    ISINSCOPE('Table'[City]) || ISINSCOPE('Table'[Street]),BLANK(),
    [some measure]
  )

If it still doesn't work, post some sample data and I can try mocking it up.