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

[Anonymous]

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!

[V-pazhen-msft]

@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]

Hi @Anonymous 

Can you provide a data sample?

Many Thanks

Mariusz

[Anonymous]

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?