Forum Discussion

mterry's avatar
mterry
Helper V
4 years ago
Solved

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[Sp...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    4 years ago
    =
FILTER(
    SUMMARIZECOLUMNS(
        SA[Fiscal Year],
        SA[Operating Unit Name],
        SA[Supplier],
        "Annual Spend", SUM( SA[Spend in Euro] )
    ),
    [Annual Spend] <> 0
)
CNENFRNL's avatar
CNENFRNL
Community Champion
4 years ago
=
FILTER(
    SUMMARIZECOLUMNS(
        SA[Fiscal Year],
        SA[Operating Unit Name],
        SA[Supplier],
        "Annual Spend", SUM( SA[Spend in Euro] )
    ),
    [Annual Spend] <> 0
)