Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
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[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's avatar
    CNENFRNL
    Icon for Community Champion rankCommunity Champion
    =
    FILTER(
        SUMMARIZECOLUMNS(
            SA[Fiscal Year],
            SA[Operating Unit Name],
            SA[Supplier],
            "Annual Spend", SUM( SA[Spend in Euro] )
        ),
        [Annual Spend] <> 0
    )
  • Anonymous's avatar
    Anonymous
    Not applicable

    Worked Perfectly, thank you!