Forum Discussion

MBisceglia's avatar
MBisceglia
Frequent Visitor
4 years ago
Solved

How to hide values when expanding subcategories in Matrix

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

 

  • Whitewater100's avatar
    Whitewater100
    4 years ago

    Hi:

    Can you try

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

     

     

5 Replies

  • Whitewater100's avatar
    Whitewater100
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi:

    Can you try

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

     

     

    • MBisceglia's avatar
      MBisceglia
      Frequent Visitor
      4 years ago

      Hmm this didn't work, but thanks anyways!

    • GiaPa's avatar
      GiaPa
      Frequent Visitor
      2 years ago

      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)?

  • CNENFRNL's avatar
    CNENFRNL
    Icon for Community Champion rankCommunity Champion
    4 years ago
    var __vacancy =
DIVIDE(
    COUNTROWS( FILTER( Table, Table[Status] = "Vacant" ) ),
    COUNTROWS( Table ),0
)
return if(__vacancy<1,__vacancy)