Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

How do I divide a median by a median, same columns but different categories?

Hello, and thank you so much for your time helping me!

 

I am analyzing properties and their sales prices. I have three columns. One is called "Property Type" the second is called "Property SubType" and the third is called "ClosePrice". 

 

I am trying to get the median of the "ClosePrice" for "Property Type" called "Single-Family" and the median of the "ClosePrice" for "Property Type" called "Rental" for a property subtype of single family.

 

For example: Area 10 on the real estate map has a median close price for single family homes of $225,000. The median close price for rentals which are single-family type is $2,100. Likewise, I would do the same for townhouses or condos or apartments, etc.

 

After that, I want a column that multiplies the median of rentals by 12 and call it "Rent Revenue".

 

Then I wish to have a column that divides the rent revenue by the median close price for single family called "Cap Rate".

 

For example: Area 10 on the real estate map has a median close price for single family homes of $225,000. The median close price for rentals which are single-family type is $2,100. The area's cap rate is 11.2%. 

 

Can I use filters to change from one type of property to another and see the visualized results or is it set as a measure in stone? Thanks again!

3 REPLIES 3
V-pazhen-msft
Community Support
Community Support

@Anonymous 

I think there are a bit too much information for us to picture, if you can provide your sample pbix without sensitive numbers would be best. 

Paul

Mariusz
Community Champion
Community Champion

Hi @Anonymous 

 

Can you provide a data sample?

 

Many Thanks

Mariusz

 

Anonymous
Not applicable

Thanks Mariusz for the help. Sure, here is a sample:

 

Subdivision:

Tanglewood

River Oaks

Montrose

 

Address

123 Main St.

234 Alpha St.

567 Beta St.

678 Golf St.

910 Fox St.

 

Property Type:

Lots

Single family

Townhouse/Condo

Rental

 

Property SubType:

Single Family Detached

Townhouse Condominium

Mid-Rise Condominium

 

Closed Price:

$225,000

$245,000

$280,000

$1,875

$1,950

$2,150

 

From this set I should be able to say "In Tanglewood, the single family detached properties have a median sales price of XYZ dollars and a median rent price of ABC dollars. There is a CAP rate of X% for this area because ABC dollars x 12 months = $Annual Rent. $Annual Rent divided by XYZ dollars = X%. Is that sample set above shown right for you?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.