Forum Discussion

GlynMThomas's avatar
GlynMThomas
Resolver I
5 years ago
Solved

Sum By Column

Hi,   I have a table like below:   Name Group Month Amount Bob Tennis Jan 100 Bob Football Jan 50 Fred Tennis Jan 50 Mary Football Feb 40 Mary Golf Jan 300 ...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    GlynMThomas 

    You can use the measure to filter a visual. Im not sure I understand what you need. If it's a calculated column in the table above, then:

    Flag =
VAR amountCustomerMonth_ =
    CALCULATE (
        SUM ( Table1[Amount] ),
        ALLEXCEPT ( Table1, Table1[Name], Table1[Month] )
    )
RETURN
    IF (
        amountCustomerMonth_ > 100,
        "Paying over 100 quid",
        "NOT paying over 100 quid"
    )

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

AlB's avatar
AlB
Community Champion
5 years ago

GlynMThomas 

I'm not sure who you're replying to. The solution above works as intended. See it all at work in the attached file.

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

 

  • GlynMThomas's avatar
    GlynMThomas
    Resolver I
    5 years ago

    AlB 

     

    It does for a measure, but I need to apply that to to a filter so I can filter between over £100 and under £100. I can't put a measure in a filter.

     

    Many Thanks