cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## How to subtract a row value from overall measure

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

3 REPLIES 3
Frequent Visitor

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.

Super User

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?

Frequent Visitor

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.