Forum Discussion
Anonymous
4 years agoNot applicable
Filtering on new summarized column when creating a new table
I'm creating a new summarized table from an existing table, but would like to add a filter based on the new column I'm creating. I've tried the below with no luck, also tried replacing the 'SUM(SA[Spend in Euro])' with the name of the new column, "Annual Spend" to no avail. Is it possible to do what I'm attempting and have the final result be a summary table without any Annual Spend values that sum to 0?
Summarized Spend = CALCULATETABLE(
SUMMARIZE(
SA,
SA[Fiscal Year],
SA[Operating Unit Name],
SA[Supplier],
"Annual Spend", SUM(SA[Spend in Euro])
),
SUM(SA[Spend in Euro]) <> 0
)= FILTER( SUMMARIZECOLUMNS( SA[Fiscal Year], SA[Operating Unit Name], SA[Supplier], "Annual Spend", SUM( SA[Spend in Euro] ) ), [Annual Spend] <> 0 )
2 Replies
- CNENFRNL
Community Champion
= FILTER( SUMMARIZECOLUMNS( SA[Fiscal Year], SA[Operating Unit Name], SA[Supplier], "Annual Spend", SUM( SA[Spend in Euro] ) ), [Annual Spend] <> 0 ) - AnonymousNot applicable
Worked Perfectly, thank you!