Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I've a table contains projectCode and other information plus total budget.
I need to get sum of budget from but of 1st row of each budget for that purpose I've written a DAX like below. Working perfect.
But low performance. How can i optimize this DAX.
Total budget :=
CALCULATE(
SUMX(
SUMMARIZE(
Table,
Table[ProjectCode],
"MAX Budget", MAX(Table[TotalBudget])
),
[MAX Budget]
)
)
Thanks
Solved! Go to Solution.
Please try this expression instead
Total budget :=
VAR summary =
SUMMARIZE (
Table,
Table[ProjectCode],
"MAX Budget", MAX ( Table[TotalBudget] )
)
VAR result =
MAXX ( summary, [MAX Budget] )
RETURN
result
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @adeelnazir ,
I checked the optimization formula provided by @mahoneypat and thought it was a good choice. You can test it.
If you still have questions, I suggest you provide the corresponding data model so that I can answer you as soon as possible.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please try this expression instead
Total budget :=
VAR summary =
SUMMARIZE (
Table,
Table[ProjectCode],
"MAX Budget", MAX ( Table[TotalBudget] )
)
VAR result =
MAXX ( summary, [MAX Budget] )
RETURN
result
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |