Forum Discussion
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 ...
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
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
