Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Aggregating Results Messes Up Filter

I have a calculation (CompItem_IncExc_Flag) in a table structure that is showing up correctly.


However, when I try to filter off that column I'm not getting the right #'s.  I would expect the 6/29 values to show 21.51.  The addition of item 1 &2.  It would not add item 3 since the first purchase date occured after the minimum slicer date



What is the right calculation?


The PBIX file can be found here:



Helpful resources


August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors