The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hoping to get some clarity about how the ALL() (aka removefilter) function behaves inside FILTER() when using a measure in a chart that should be removing external filter context be it a pivot table or a chart.
I found this formula used in a video from Sam McKay in this video where he attempts to describe what is happening as: "The max date is always going to equal to the actual date. That's why we can create this running total.". His definition of actual date show's his cursor pointing to external/evaluation context from a table in a canvas report. My understanding is the ALL() function should be removing the external filter context but that doesn't seem to be the case with the formula below used in the video I provided a link to:
30 Day Running Total =CALCULATE( [Total Sales],FILTER( ALL( Dates ),Dates[Date] > MAX( Dates[Date] ) - 30 &&Dates[Date] <= MAX( Dates[Date] ) ) )
The expression seems to be correct, could you share some sample data give the expression of [Total Sales] and also share the expected result?
Regards,
Jimmy Tao
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
79 | |
77 | |
47 | |
38 |
User | Count |
---|---|
148 | |
116 | |
65 | |
64 | |
54 |