Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register 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! |
User | Count |
---|---|
84 | |
78 | |
70 | |
47 | |
41 |
User | Count |
---|---|
108 | |
53 | |
50 | |
40 | |
40 |