cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
texmexdragon
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]))
 
texmexdragon_3-1638379071850.png

 

Date filter expanded to all dates, no filter applied.  

 

texmexdragon_0-1638378635659.png

 

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

 

texmexdragon_1-1638378819916.png

 

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

 

texmexdragon_2-1638378933346.png

 

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

1 REPLY 1
lbendlin
Super User
Super User

This article may help?

 

All the secrets of SUMMARIZE - SQLBI

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

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 May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!