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.
Hey guys,
situation is the following:
I have a sales-table containing the following columns
The linetotal represents 'Price * Quantity' for that individual product in the specific order.
It is possible for 1 ordernumber to contain multiple products and therefore also multiple linetotals.
How do I calculate the order total (so add up all linetotals per ordernumber) using a DAX measure?
Thanks!
~ Niels
Solved! Go to Solution.
Hi @Niels_NL,
if you show these information by chart (column chart, line chart, ...) it will automatically sum and group by context(orderno/prodno) for you when you drag&drog ordernumber/productno to legend field.
And if you want to see order header and order details in same control, you should use Matrix(top left of picture) not table (top right of picture)
Hi @Niels_NL,
if you show these information by chart (column chart, line chart, ...) it will automatically sum and group by context(orderno/prodno) for you when you drag&drog ordernumber/productno to legend field.
And if you want to see order header and order details in same control, you should use Matrix(top left of picture) not table (top right of picture)
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |