Forum Discussion
How To Filter Based on Sum Column
To Get the Solution, I have utilized the GROUP BY feature of the query editor.
Follow the screenshots for the solution.GROUP BYCONDITIONAL COLUMNFILTER THE COLUMN
ytc-reports There are several other way to do this...
1) Once you create your table visualization with User and Quantity
go to Visaul Level Filters and select Show items when the value: is greater than 15
This would work the same way whether you just use the
Quantity Column or create a
Quantity Measure = SUM ( Table[Quantity]) or
Quantiy Measure per User = CALCULATE ( SUM('Table'[Quantity]), ALLEXCEPT('Table', 'Table'[User]) )
2) You can create another Measure based on the last one above
Quantity per User > 15 = CALCULATE ( [Quantiy Measure per User], FILTER ('Table', [Quantiy Measure per User] > 15) )
then when you create a table visualization with just User and this Measure
you'll get the result you want with no need to use the Visual Level Filters
It's up to you which way fit best in your case! :smileyhappy:
Just for example, let's say I had the following list of rows:
| User | Warehouse Number | Quantity |
| Sam | ABC | 14 |
| Sam | BCD | 14 |
| Josh | CDE | 10 |
| Josh | DEF | 3 |
When I take out the Warehouse Document Number, it looks like this:
| User ID | Quantity |
| Sam | 28 |
| Josh | 13 |
I want to add a filter that filters out the *second table* based on Quantity below 15, so that it would only show the Sam row (and any other User with a sum > 15). But at the moment, when I filter based on Quantity below 15, it would filter out *each individual row* from the top table, leaving me with nothing.
To Get the Solution, I have utilized the GROUP BY feature of the query editor.
Follow the screenshots for the solution.GROUP BYCONDITIONAL COLUMNFILTER THE COLUMN