topic Re: How to hide values when expanding subcategories in Matrix in DAX Commands and Tips

How to hide values when expanding subcategories in Matrix

MBisceglia — Fri, 04 Mar 2022 22:20:15 GMT

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

Re: How to hide values when expanding subcategories in Matrix

Whitewater100 — Sat, 05 Mar 2022 00:42:39 GMT

Hi:

Can you try

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

Re: How to hide values when expanding subcategories in Matrix

CNENFRNL — Sat, 05 Mar 2022 00:58:28 GMT

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

Re: How to hide values when expanding subcategories in Matrix

MBisceglia — Mon, 07 Mar 2022 00:19:08 GMT

Thanks! this worked!

Re: How to hide values when expanding subcategories in Matrix

MBisceglia — Mon, 07 Mar 2022 00:20:30 GMT

Hmm this didn't work, but thanks anyways!

Re: How to hide values when expanding subcategories in Matrix

GiaPa — Mon, 22 Apr 2024 15:37:02 GMT

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