Need Help with Sax

Question

Hello guys,&nbsp;&nbsp;I want to count all different bookings that happened within a calendar year and have a specific status.&nbsp;&nbsp;I used the following formula which is of course wrong 🙂 Up to the part with the date I think I am right, I want to add the part that will only count bookings in the column "Status" it&nbsp;is either paid or confirmed.&nbsp;Measure =CALCULATE(&nbsp; &nbsp; DISTINCTCOUNT(&nbsp; &nbsp; &nbsp; &nbsp; Bookings[Booking number]),&nbsp; &nbsp; &nbsp; &nbsp; YEAR(Bookings[Check-out date] = 2023))&nbsp;Wishing you a happy new year

dangar332 · Accepted Answer

Hi,&nbsp;Samhunt&nbsp;try belowMeasure =
CALCULATE(
    DISTINCTCOUNT(
        Bookings[Booking number]),
      filter(
        all(Bookings[Check-out date],Bookings[status]),
        YEAR(Bookings[Check-out date]) = 2023 &amp;&amp;
        Bookings[status] ="paid" || Bookings[status] ="confirmed"
      )
)

Forum Discussion

Need Help with Sax

2 Replies