Help in DAX query

[gushal]

Hi,

I have two tables called Opportunity and Bookings. One opportunity can be related to one or many bookings.

There is a column in Booking table called BookingFrom with 4 different values, 16001, 16002, 16003 and 16004. 

I want to filter out how many opportunities has bookings with more than one values of 16001 or 16002. So either have 2 or more bookings with BookingFrom 16001, or 2 or more bookings with BookingFrom 16002 or 2 or more bookings with BookingFrom where one of the booking has 16001 and another booking has 16002. 

Anyone know how to create measure for this?

Thanks,

Gustav

[v-jingzhang]

Hi @gushal 

Can you provide some sample data and expected result? It will greatly help us understand what you are after and provide a more detailed and specific measure based on that. 

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Community Support Team _ Jing

[amitchandak]

@gushal ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Do we have opportunity ID in booking? opportunity  both fact and dimension ?

[gushal]

Hi,

We have opportunity ID in booking.