Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I have created a calculated table with the following DAX formulae:
Solved! Go to Solution.
Hi @Tomo2709,
From your description, the SUMMARIZE function could do multiple sum in a formula, you could refer to the example code
SUMMARIZE(ResellerSales_USD , DateTime[CalendarYear] , ProductCategory[ProductCategoryName] , "Sales Amount (USD)", SUM(ResellerSales_USD[SalesAmount_USD]) , "Discount Amount (USD)", SUM(ResellerSales_USD[DiscountAmount]) )
in below link:
https://docs.microsoft.com/en-us/dax/summarize-function-dax
Regards,
Daniel He
Hi @Tomo2709,
From your description, the SUMMARIZE function could do multiple sum in a formula, you could refer to the example code
SUMMARIZE(ResellerSales_USD , DateTime[CalendarYear] , ProductCategory[ProductCategoryName] , "Sales Amount (USD)", SUM(ResellerSales_USD[SalesAmount_USD]) , "Discount Amount (USD)", SUM(ResellerSales_USD[DiscountAmount]) )
in below link:
https://docs.microsoft.com/en-us/dax/summarize-function-dax
Regards,
Daniel He
I forgot to name the column for the second sum function thank you for your help. Works perfectly.
Paul
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
98 | |
89 | |
73 | |
62 | |
61 |