Forum Discussion
Filtering assistance
All, I am sure there is an easy solution to this problem but I cannot find it! Anyways here goes: We have a database that contains transaction lines, for simplicity we have 3 columns, sub nam...
Anonymous Create a Group Sales Measure - which calculates the Total at the Group Level!
Assuming that is the Total level you want to filter :smileyhappy: You can of course change this to Sub Name
Group Sales Measure = CALCULATE ( SUM ( 'Table'[Sale Value] ), ALLEXCEPT ( 'Table', 'Table'[Group Name] ) )Drag this Measure to the Visual level filters and select Show items when the value is: greater than or equal to type 100000
And here's the result:
Anonymous Create a Group Sales Measure - which calculates the Total at the Group Level!
Assuming that is the Total level you want to filter :smileyhappy: You can of course change this to Sub Name
Group Sales Measure =
CALCULATE (
SUM ( 'Table'[Sale Value] ),
ALLEXCEPT ( 'Table', 'Table'[Group Name] )
)
Drag this Measure to the Visual level filters and select Show items when the value is: greater than or equal to type 100000
And here's the result: