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:
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:
It turns out the 'visual level filters' is all I needed. Thank you all for your help.