Measure that Adds a Measure's Result

Nnamarie_1997 — Fri, 12 Jan 2024 04:05:01 GMT

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 🙂

Re: Measure that Adds a Measure's Result

saurabhtd — Fri, 12 Jan 2024 05:05:56 GMT

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] )

Re: Measure that Adds a Measure's Result

Nnamarie_1997 — Fri, 12 Jan 2024 06:27:48 GMT

Thanks a lot, saurabhtd 🙂

topic Re: Measure that Adds a Measure's Result in DAX Commands and Tips

Measure that Adds a Measure's Result

Re: Measure that Adds a Measure's Result

Re: Measure that Adds a Measure's Result