How to subtract a row value from overall measure

[Sowmya18]

Hi ,

I'm looking for DAX calculation for below. I'm looking to substract "OT $$" value which is 11,496,557 from "Regular $$" amount 

Regular $$ = Regular - O/T (3,036,088,683.84-11,496,557.01=3,024,592,126.83).

[Sowmya18]

Thank you Vahid for replying me back. Here I have calculated this column based on the Benifits field,

if Benifits = "O/T $$"then Total Amount * 3 , if Benifits = "Benifits $$" then Total Amount and If Benifits = "Regular $$" then I want the result as (TotalAmount *2 )- O/T $$.

I could create a calculation till the Total amount multipling but I'm not getting how to substract the O/T value from the Regular Total Amount value.

If you see below Total Amount for O/T is 11,496,557.01 and i have calculated Regular Total Amount - (1,518,044,341.92)*2 =3,036,088,683.84 . Now I want to exclude Regular - O/T= (3,036,088,683.84)-(11,496,557.01)=3,024,592,126.83. 

[VahidDM]

Hi @Sowmya18 

How do you want to show the result (that 3,024,592,126.83)? can you share a result in table or any other visual you are looking for?

Appreciate your Kudos!!

[Sowmya18]

Thank you Vahid for replying me back. Here I have calculated this column based on the Benifits field,

if Benifits = "O/T $$"then Total Amount * 3 , if Benifits = "Benifits $$" then Total Amount and If Benifits = "Regular $$" then I want the result as (TotalAmount *2 )- O/T $$.

I could create a calculation till the Total amount multipling but I'm not getting how to substract the O/T value from the Regular Total Amount value.

If you see below Total Amount for O/T is 11,496,557.01 and i have calculated Regular Total Amount - (1,518,044,341.92)*2 =3,036,088,683.84 . Now I want to exclude Regular - O/T= (3,036,088,683.84)-(11,496,557.01)=3,024,592,126.83.