How to hide values when expanding subcategories in Matrix

[MBisceglia]

Hi everyone, 

Is it possible to hide values of a column as we expand a matrix? Here's what my matrix looks like, I trying to hide the 100%:

This is obviusly because if the measure I created ("Vacancy Rate") is only accounting the rows in which status="Vacant". Here's my measure:  

Vacancy Rate = DIVIDE(COUNTROWS(FILTER(Table,Table[Status]="Vacant")),COUNTROWS(Table))

Maybe the solution is to modify the DAX for the measure. 

Thanks in advance, 

Michelle

[CNENFRNL]

var __vacancy =
DIVIDE(
    COUNTROWS( FILTER( Table, Table[Status] = "Vacant" ) ),
    COUNTROWS( Table ),0
)
return if(__vacancy<1,__vacancy)

[MBisceglia]

Thanks! this worked!

[Whitewater100 · Accepted solution]

Hi:

Can you try

Vacancy Rate 
var  VR =DIVIDE(COUNTROWS(FILTER(Table,Table[Status]="Vacant")),COUNTROWS(Table))
return
CALCULATE(VR, Table[Department] <> "vacant")

[GiaPa]

How would that formula look like if the row label was not always showing "vacant" but was another field instead in a secondary expandable row (so not a value of department)?

[MBisceglia]

Hmm this didn't work, but thanks anyways!