In this example we will work through how to use the ALLEXCEPT function to prevent a cumulative total from resetting every time a date selection is change in a Power BI report.
This was a recent question from the Enterprise DNA Support Forum where a member had a real world use case to solve for this particular piece of analysis.
This is a great review of how ALLEXCEPT work within the CALCULATE function when using the cumulative total pattern in DAX.
Sam
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn
FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv
FREE – Power BI Resources – https://ift.tt/2LiAVQj
FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95
Learn more about Enterprise DNA – https://ift.tt/2LiAWDR
Enterprise DNA Membership – https://ift.tt/2IJLxWD