Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
I am trying to add a dynamic filter on one of my measures. I need the sumx but to filter dynamically on the selected date. Below is my current measure that I am trying to work through.
SUMX expects a table expression and an aggregation expression. Your SUMX includes a VALUES expression (another table expression) where the aggregation should be. So remove the VALUES expression.
Proud to be a Super User!
Paul on Linkedin.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.