Forum Discussion

FStettler's avatar
FStettler
Icon for Helper I rankHelper I
6 years ago

Accumulate values throughout dates with other filter contexts

Hello!   I'm trying to get a DAX formula that will accumulate counted values throughout the calendar dates in a Clustered column chart, but also taking into consideration additional filter contexts...
Need Help
v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi FStettler ,

 

Would you please try the following measure:

Measure =

CALCULATE (

    COUNT ( BOOKINGS[Accomodation Date] ),

    FILTER (

        ALLSELECTED ( BOOKINGS ),

        BOOKINGS[Booking Date] <= MAX ( BOOKINGS[Booking Date] )

    )

)

Best Regards,

Dedmon Dai

FStettler's avatar
FStettler
Icon for Helper I rankHelper I
6 years ago

v-deddai1-msft Hi again!

 

Just if you could explain why my DAX wasn't working?

I mean, as per my concern, by using FILTER I'm creating a subset of a table applying the filter conditions set out within the FILTER formula, which was "<=".

Why would it only behave as if it was "="?

But then ALLSELECTED() would get the job done?

It's still unclear to me.

 

Thanks so much once again.

Kind regards,

Facundo.