Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

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...
Need Help
  • Sean's avatar
    Sean
    10 years ago

    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:

     

kcantor's avatar
kcantor
Community Champion
10 years ago

Create a calculation for the visual.

'Type A transactions' = CALCULATE([Total Sales], [Line Amount]>1000000) Or something similar should work.

this shows using the filter within the calculation. Other lines will be blank. You will need lookup tables for the sub name, group name, and date so that you can populate the axis appropriately.