topic Re: Need Help with Sax in DAX Commands and Tips

Need Help with Sax

Samhunt — Sat, 30 Dec 2023 13:22:06 GMT

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 with the date I think I am right, I want to add the part that will only count bookings in the column "Status" it is either paid or confirmed.

Measure =

CALCULATE(

DISTINCTCOUNT(

Bookings[Booking number]),

YEAR(Bookings[Check-out date] = 2023)

)

Wishing you a happy new year

Re: Need Help with Sax

Dangar332 — Sat, 30 Dec 2023 13:31:08 GMT

Hi, Samhunt

try below

Measure = 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" ) )

Re: Need Help with Sax

Fowmy — Sat, 30 Dec 2023 14:25:40 GMT

Samhunt

One more version:

Measure1 = CALCULATE ( DISTINCTCOUNT ( Bookings[Booking number] ), YEAR ( Bookings[Check-out date] ) = 2023, Bookings[status] IN { "Paid", "Confirmed" } )