topic Re: Cumulative measure / 100 in DAX Commands and Tips

Cumulative measure / 100

giuliapiazza94 — Fri, 02 Aug 2024 07:18:09 GMT

Hi guys,

i need to create a measure that works like this:

How can I create it?

Thank you all 🙂

Re: Cumulative measure / 100

bhanu_gautam — Fri, 02 Aug 2024 07:23:12 GMT

giuliapiazza94 , Can you explain what exactly you are trying to do

Re: Cumulative measure / 100

giuliapiazza94 — Fri, 02 Aug 2024 07:33:55 GMT

X and Y are two measures.

X = total of new customers of month

Y = total customers

I need to create Z:

Z of first month selected (in this example is january) = Y / 100

Z of other months = Z(previous month) + X

Re: Cumulative measure / 100

giuliapiazza94 — Fri, 02 Aug 2024 07:34:36 GMT

I need to create Z but I don't know how

Re: Cumulative measure / 100

Anonymous — Mon, 05 Aug 2024 01:52:24 GMT

bhanu_gautam , Thank you for your positive response to the post.

Hi giuliapiazza94

Here is my solution, I hope this helps.

1.Create a measure to calculate Y/100.

FirstMonthYDiv100 = CALCULATE( MIN('Table'[Y]), FILTER( ALL('Table'), 'Table'[Month] = MINX(ALL('Table'), 'Table'[Month] ) ) )/100

2.Create a cumulative measure for column X.

CumulativeSumX = CALCULATE( SUM('Table'[X]), FILTER( ALLSELECTED('Table'), 'Table'[Month] <= MAX('Table'[Month]) ) )

3.Create a measure Z.

Z = [FirstMonthYDiv100] + [CumulativeSumX]

4.Here is my final result.

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.