Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am trying to create a measure that would sum the totals from each of these so i can add it in below and do additional measures off of this. When I try to just sum, it still breaks it out under each PO Number or Order Number instead of just creating 1 line showing 2,162. Any help is appreciated!
I hope this message finds you well. I've noticed that this solution remain unresolved. If any of you have managed to find a resolution to the issue, I kindly request that you share your solution for the benefit of the entire community. Alternatively, if you're still facing challenges, please do let us know as well.
Your insights and updates will greatly assist others who might be encountering the same challenge.
Hi @Bryanna , you can try this:
measure = CALCULATE ( SUM(Table[Field), ALL(Table) )
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
That didnt work. It still broke it out under each order number. Example below.
PO or Order Number | Part Number |
123456789 | 1205 |
Total | 1205 |
784553515 | 472 |
Total | 472 |
658745953 | 485 |
Total | 485 |
Can you send a screen shot of what you see? Using All should have removed the PO or Order Number Filter. And the fact that it isn't makes me think there is another filter being applied.
Here you go. I know I can just do the sum on the column subtotals but i need to use the qty in another calculation as well so really need it in a measure.
PO or Order Number | Part Number |
123456789 | 1205 |
784553515 | 472 |
658745953 | 485 |
Total Qty | 2,162 |
If you are trying to get the total quanity, it will look something like this.
Calculate(Sum(PartNumber), All(PO or Order Number))
If this post was helpful, please kudos or accept the answer as a solution.
~ Anthony Genovese
Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!
Can you provide a mockup of how you want it to look?
User | Count |
---|---|
57 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |