Showing results for 
Search instead for 
Did you mean: 
Super User
Super User

Summarize table not filtering properly when date slicer is used

Hello Community  - I have created a table using Summarize with the objective of having a distinct table that summarizes the "count" of returned items.    In other words, I wanted to know how many instances of item "xyz" or "abc" there are.   Or put another way, how many times does item "xyz" show up as a returned item.    I then used the Group feature to create different bins based on those values.    The idea being that items that show up as a return more than 50 times would show up in that bin (see below), items that show up 26 to 50 times would show up in that bin, etc.  


That visual essentially works together with the other visual to its left.    So, if I filter on the 26 to 50 bin, it will then highlight those items that are associated.   In other words, all of the items that show up as return item between 26 and 50 times.  


The problem occurs when I use the date filter.   If I adjust the date filter at all, the visual on the left no longer returns correct values.    I had thought since there is a relationship between the tables that the newly created table would adjust accordingly based on whatever date values where selected...but its not.   It only works correctly when the date table is not filtered at all.  


Below are the relevant ingredients to my problem.   Any help is greatly appreciated!




Table = SUMMARIZE(RMAItems_Query,RMAItems_Query[RMA Item To Return],"Frequency",COUNT(RMAItems_Query[RMA Item To Return]))


Date filter expanded to all dates, no filter applied.  




Date filter expaned to all dates, filter applied on 26 to 50: 




Date filter adjusted, and you can see now that the visual on the left is not filtering properly: 





Super User
Super User

Super User
Super User

This article may help?


All the secrets of SUMMARIZE - SQLBI

Helpful resources

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Kudoed Authors