Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
rob2
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

PowerBI_Qv2.jpg

 

What is the right calculation?

 

The PBIX file can be found here:  https://www.dropbox.com/s/wz8m2sv7h1ieeu3/Competitor_Example%20v2.pbix?dl=0

 

Thanks.

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.