Cumulative Totals Not Working with Multiple Filters Unless All Selected

[awwolfe]

I'm running into what looks like a bug with a DAX calculating cumulative totals with more than one filter is in use.  When more than one filter is in use and neither of them have the "select all" selection, some of the values drop out of the running total.  It is pretty easy to replicate with the pbix file linked here.  Link to PBIX file   "Deposit Week" is a 55 week annual cycle that is used in my organization. 

This is the DAX calculating the running total "Running_deposits":

Running_Deposits = CALCULATE(

COUNT('test_data'[ID]),

FILTER(

ALLEXCEPT('test_data', 'test_data'[Admit_Status], 'test_data'[START_TERM]),

'test_data'[Deposit_Week] <= max('test_data'[Deposit_Week])

)

)

Below, running totals not working, F3 values not not in the final total. 

Below, shows the correct running total for FA/16 data filtered by FA and F3 admit status.  Only works if Start Term has nothing selected or Select All.  Any other combination of selections breaks the running total. 

[Anonymous · Accepted solution]

hi @awwolfe ,

Please modify your measure as below and see if it achieve your exception:

Running_Deposits = CALCULATE(

    COUNT('test_data'[ID]),

    FILTER(

        ALLSELECTED(test_data[APPS_DEPOSIT_DATE],test_data[Deposit_Week],test_data[ID],test_data[Admit_Status]),

        'test_data'[Deposit_Week] <= max('test_data'[Deposit_Week])

    )

)

Result would be shown as below:

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[awwolfe]

Jay,  

Thanks much, this works. 

Andrew