Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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":
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.
Solved! Go to 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.
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.
Jay,
Thanks much, this works.
Andrew
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |