Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
)
Solved! Go to Solution.
=
FILTER(
SUMMARIZECOLUMNS(
SA[Fiscal Year],
SA[Operating Unit Name],
SA[Supplier],
"Annual Spend", SUM( SA[Spend in Euro] )
),
[Annual Spend] <> 0
)
| Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Worked Perfectly, thank you!
=
FILTER(
SUMMARIZECOLUMNS(
SA[Fiscal Year],
SA[Operating Unit Name],
SA[Supplier],
"Annual Spend", SUM( SA[Spend in Euro] )
),
[Annual Spend] <> 0
)
| Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.