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
FStettler's avatar
FStettler
Icon for Helper I rankHelper I
6 years ago

Hi mahoneypat thanks a million for your swift response.

 

I'm afraid it didn't help much as I can't even lock it in. I get this error message:

"A single value for column 'Booking Date' in table 'BOOKINGS' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."

 

Looks like formula ALL won't take a filter context as an argument.

Thanks again.

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 This absolutely has got the job done.

     

    Thanks a million!

    Facundo

  • 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.