Forum Discussion

Wise1's avatar
Wise1
Icon for Helper I rankHelper I
9 years ago

DAX Formula for subtracting

Hello All,   I have been trying to figure the following out for the last 2 days without any luck,    Basiclly what iam trying to achieve is  Client - has allocated 10 hours a month 4 hrs worth ...
Need Help
Wise1's avatar
Wise1
Icon for Helper I rankHelper I
9 years ago

I see now where you mean data type was set as text 

ive changed it to decimal number now 

 

 

myValue = sla[SLA Hours] - Allocated SLA hours

MeasureTotalTimespentOrg = SUM(view_tm_audit[TimeSpent]) - Actual time spent which is summed up to be minus'd from allocated hrs

 

myValue1 = sla[SLA Hours]-sla[MeasureTotalTimespentOrg]

 

Ignore that i dont have the myValue1 in the below pic, was just one i made up for a screenshot 

 

 

 

wynhopkins's avatar
wynhopkins
Icon for Most Valuable Professional rankMost Valuable Professional
9 years ago

 

 

 

Build this first:

 

SLAHours = Sum(sla[SLA Hours])

 

 

Then this..

 

 

SLAHrsCalculatedPerClient = SUM(sla[MeasureTotalTimespentOrg])

 

 

Finally this

 

SLAHrsMinusFromAllocated = [SLAHrsTotal] - [SLAHrsCalculatedPerClient]