Forum Discussion
Calculate Sumx aggregation - filter context - issue
Install DAXDebugOutput and learn how to use EVALUATEANDLOG
Community SupportHi BB912554,
Thank you lbendlin for your response and it works.
Here's the DAX measure that you might find helpful:
M_test =
CALCULATE(
SUMX(
FILTER(ALL(Tbl1), Tbl1[Product] = "B"),
Tbl1[Volume] * Tbl1[Price per piece]
)
)
The DAX measure provided by the super user is also working correctly and fulfills the requirement as expected.
I'm attaching the .pbix file with the working DAX and sample data, so you can explore the logic and test it yourself directly.
Community SupportHI BB912554
As we did not get a response, may I know if the above reply could clarify your issue, or could you please help confirm if we may help you with anything else?
And if the provided information meets your requirements, you can Accept the solution and also give Kudos on that reply. It helps other users who are searching for this same information and find the information.
Your understanding and patience will be appreciated.