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 have a detail table as follow:
Table name: Daily Transaction
then create a new table to distinct delivery number
the problem is formula of sum Volume doesn't work.
CALCULATE(SUMX('Daily Transaction','Daily Transaction'[Volume]))
Thanks,
Ratana
Solved! Go to Solution.
Hi @RatanaPOUY ,
You may create measure like DAX below.
Sum Volume= CALCULATE(SUM('Daily Transaction'[Volume]),FILTER(ALLSELECTED('Daily Transaction'), 'Daily Transaction'[Delivery] =MAX('Daily Transaction'[Delivery])))
Or you can just change the show aggregation of Volume to Sum.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @RatanaPOUY ,
Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best regards
Amy
Hi @RatanaPOUY ,
You may create measure like DAX below.
Sum Volume= CALCULATE(SUM('Daily Transaction'[Volume]),FILTER(ALLSELECTED('Daily Transaction'), 'Daily Transaction'[Delivery] =MAX('Daily Transaction'[Delivery])))
Or you can just change the show aggregation of Volume to Sum.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'm not sure what is the purpose of the new table, but if you only require to achieve the result of summing the Volumn column based on Delivery, then you can access "Edit Query", duplicate the original Table, Go to Transform tab, and then click on the Group By function, this will show a dialog in which you will chose the parameters of groupings and the aggregation you need.
however, if the purpose is only to show the results in a visual, then this can be achieve by simple aggregation on the visual itself.
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |