Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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! |
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 61 | |
| 46 | |
| 40 | |
| 38 | |
| 22 |
| User | Count |
|---|---|
| 176 | |
| 131 | |
| 118 | |
| 82 | |
| 54 |