Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, good day!
I am currently working on obtaining the total sales for our company. For me, the easiest way to calculate the total sales is by adding a new column [New Column = SP * QTY]. However, I don't want to use a new column because I need to apply this calculation to each partition of the Fact Table in SSAS, and we already have a lot of partitions.
That's why I need your help. Is there any way to use a measure for this?
Here's the sample:
Measure to get the Sales >> Sales = SUM(Sheet1[QTY]) * SUM(Sheet1[SP])
And now I want to add the Sales by Group,
but I don't know how to create a measure to get 2850 & 3650.
(In this pic, I used a calculated column not measure)
Can somebody help me?
Thanks in Advance 🙂
Solved! Go to Solution.
@Nnamarie_1997 You can use below measure. This measure will give the result what you are looking. Since SUMX does row wise calculation.
sales = SUMX(sheet1, Sheet1[QTY] * Sheet1[SP] )
@Nnamarie_1997 You can use below measure. This measure will give the result what you are looking. Since SUMX does row wise calculation.
sales = SUMX(sheet1, Sheet1[QTY] * Sheet1[SP] )
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
69 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
127 | |
32 | |
27 | |
24 | |
22 |