SamhuntHelper II2 years agoSolvedNeed Help with Sax Hello guys, I want to count all different bookings that happened within a calendar year and have a specific status. I used the following formula which is of course wrong 🙂 Up to the part w...Show MoreDangar3322 years agoHi, Samhunt try belowMeasure = CALCULATE( DISTINCTCOUNT( Bookings[Booking number]), filter( all(Bookings[Check-out date],Bookings[status]), YEAR(Bookings[Check-out date]) = 2023 && Bookings[status] ="paid" || Bookings[status] ="confirmed" ) )
Dangar3322 years agoHi, Samhunt try belowMeasure = CALCULATE( DISTINCTCOUNT( Bookings[Booking number]), filter( all(Bookings[Check-out date],Bookings[status]), YEAR(Bookings[Check-out date]) = 2023 && Bookings[status] ="paid" || Bookings[status] ="confirmed" ) )
Dangar3322 years agoHi, Samhunt try belowMeasure = CALCULATE( DISTINCTCOUNT( Bookings[Booking number]), filter( all(Bookings[Check-out date],Bookings[status]), YEAR(Bookings[Check-out date]) = 2023 && Bookings[status] ="paid" || Bookings[status] ="confirmed" ) )
FowmySuper User2 years agoSamhunt One more version: Measure1 = CALCULATE ( DISTINCTCOUNT ( Bookings[Booking number] ), YEAR ( Bookings[Check-out date] ) = 2023, Bookings[status] IN { "Paid", "Confirmed" } )
