Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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:
Solved! Go to Solution.
Hi:
Can you try
Vacancy Rate
var VR =DIVIDE(COUNTROWS(FILTER(Table,Table[Status]="Vacant")),COUNTROWS(Table))
return
CALCULATE(VR, Table[Department] <> "vacant")
var __vacancy =
DIVIDE(
COUNTROWS( FILTER( Table, Table[Status] = "Vacant" ) ),
COUNTROWS( Table ),0
)
return if(__vacancy<1,__vacancy)
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Thanks! this worked!
Hi:
Can you try
Vacancy Rate
var VR =DIVIDE(COUNTROWS(FILTER(Table,Table[Status]="Vacant")),COUNTROWS(Table))
return
CALCULATE(VR, Table[Department] <> "vacant")
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)?
Hmm this didn't work, but thanks anyways!
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
8 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
10 |