Rounding adjustments using EARLIER function.

[Anonymous]

Hello Experts, 

I am trying to achieve this using Measures and I am stuck to bring VD3 column by using Measures.
VD3 = IF(ROUND(DS[VD2],0)>=DS[Ranking],1,0)
VD2 =

ABS(SUMX(FILTER('DS','DS'[Group]=EARLIER('DS'[Group])),DS[CalcsRounded])-SUMX(FILTER('DS','DS'[Group]=EARLIER('DS'[Group])),DS[Unrounded]))

I appreciate your genius help. Thanks a lot.

[Nathaniel_C]

Hi @Anonymous ,

What error are you getting?

[Anonymous]

I am not getting any errors since I am not sure what code I should write. 
Basically what I am trying to find is VD3. VD3 = Rounded - Unrounded and this delta 3 need to apply for the first 3 accounts, if the delta is 1 only one account, the delta is 2, only first two, if the delta is 4 only first 4 acc. 

[Nathaniel_C]

Hi @Anonymous ,

IF(ROUND(MAX(DS[VD2]),0)>=MAX(DS[Ranking]),1,0)

Try this.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel 

[Anonymous]

But how do you find the VD3 (Delta)

[Nathaniel_C]

Hi @Anonymous ,

Would you give us a picture of your expected outcome?

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[Anonymous]

Hi Nathaniel_C, the Expected outcome is FN3, 
I achieved this using the EARLIER function at the table level. But need to achieve it only using measures.