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, how do I calculate Sum based on two columns.
Example (above) and expected output (bottom) :
Should I use Measure? Or create a new table instead?
Thanks!
Solved! Go to Solution.
Hi, @Anonymous
Please make sure the aggregation for 'Product_Code' is set as 'Don't summerize' and the aggregation for 'Product Qty' is set as 'Sum'.
Or you may create a measure as below.
Result = SUM('Table'[Product_Qty])
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
Please make sure the aggregation for 'Product_Code' is set as 'Don't summerize' and the aggregation for 'Product Qty' is set as 'Sum'.
Or you may create a measure as below.
Result = SUM('Table'[Product_Qty])
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , You can choose aggregation as sum or create a measure
Total product qty = Sum(Table[product_qty])
Take the other two as (so not summarize) in a table or on the row of the matrix visual .
Hi @Anonymous
just set aggregation as Sum in visual field Product_Qty settings
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |