Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Help in DAX query

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

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous ,
    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 ?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi,

       

      We have opportunity ID in booking.