Measure that Adds a Measure's Result

[Nnamarie_1997]

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 🙂

[saurabhtd · Accepted 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]

Thanks a lot, @saurabhtd 🙂