cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Customers who bought parking slot with apartment

Hey

I'm investigating apartment and parking slot sales. I need to calculate how many apartment sales will be bought with a parking slot.

1 Housing Company have parking slots and apartments.

1 apartment sale can be bought by multiple customers.

There is scenario that 1 apartment is sold with 1 parking slot to 2 customers but only 1 customer from these 2 customers bought the the parking slot. In this case the apartment is sold with parking slot.

The desired result would be like:

Apartment 1 Bought with parking slot

Apartment 2 Bought with parking slot

Apartment 3 Not bought with parking slot

After that I could make a analysis with different Housing companies with % of housing purchases with parking slot.

File:

https://www.dropbox.com/s/t1y9rx45s3z950v/Test.pbix?dl=0

Any ideas?

2 REPLIES 2
Highlighted
Super User IX

## Re: Customers who bought parking slot with apartment

So like this?

``````Measure =
VAR __All = COUNTROWS(FILTER('Items',[Type]<>"Parking Slot"))
VAR __ParkingSlots = COUNTROWS(FILTER('Items',[Type]="Parking Slot"))
RETURN
__ParkingSlots / __All``````

PBIX is attached.

---------------------------------------

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

Highlighted
Frequent Visitor

## Re: Customers who bought parking slot with apartment

Hi

Thank you for your reply @Greg_Deckler . This is still not enough.

There can be a multiple bueyrs for apartment and the measure needs to be calculated per one apartment. So if there is 3 buyers for the apartment x and one of them buy one parking slot from the same housing company, the dax should say that the apartment was sold with parking slot.

I tried to make a dax but it does not work.

Apartment sales with parking spot =
var selectedcustomer = VALUES(Customers[CustomerID])
var selectedhousingcompany = VALUES('Housing companies'[HousingCompanyID])
var apartmentsales = CALCULATE([Apartment sales];selectedcustomer;selectedhousingcompany)
var parkingslotsales = CALCULATE([Parking slot sales];selectedcustomer;selectedhousingcompany)

return
IF(apartmentsales>=1&&parkingslotsales>=1;"Yes";"No")

https://www.dropbox.com/s/wuhtqhiji3j5nmw/Test.pbix?dl=0

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021