- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

rate calculation formula
Hello,
I have a tenant table to show tenant data for every shopping center. Every shopping center has a # of units that can be rented to tenants. In the "tenant name" column it contains value "Vacant" if the unit is not rented to any tenant. The vacancy rate is calculated by taking the number of vacant units, multiplying that number by 100, and dividing that result by the total number of units. My question is what's the formula to calculate it in Power BI?
Thanks so much!
Lili
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@lilySixteen , Something like this
divide(calculate(countrows(Table), filter(Table,Table[tenant name]="Vacant")),countrows(Table))
No need multiple by 100, Mark as % column
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi,
Try below formula
Vacancyrate =
DIVIDE (
CALCULATE ( COUNTROWS ( tablename ), tablename[tenant name] = "Vacant" ) * 100,
COUNTROWS ( ALL ( tablename ) ),
0
)
Thank You,
Venkata Nalla
Follow me on LinkedIn.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@nvprasad Thank you for helping me. Your answer is correct when calculating the total but not when calculate by shopping center. Thanks again for providing your answer!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@lilySixteen , Something like this
divide(calculate(countrows(Table), filter(Table,Table[tenant name]="Vacant")),countrows(Table))
No need multiple by 100, Mark as % column
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-03-2024 02:16 PM | |||
01-02-2025 04:06 PM | |||
12-12-2024 06:57 AM | |||
03-31-2024 12:51 PM | |||
11-21-2024 10:48 PM |
User | Count |
---|---|
132 | |
105 | |
86 | |
55 | |
46 |