Forum Discussion

Wise1's avatar
Wise1
Helper 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
wynhopkins's avatar
wynhopkins
Most Valuable Professional
9 years ago

 

 

 

Build this first:

 

SLAHours = Sum(sla[SLA Hours])

 

 

Then this..

 

 

SLAHrsCalculatedPerClient = SUM(sla[MeasureTotalTimespentOrg])

 

 

Finally this

 

SLAHrsMinusFromAllocated = [SLAHrsTotal] - [SLAHrsCalculatedPerClient]

 

 

 

Wise1's avatar
Wise1
Helper I
9 years ago

Hello,

 

Just wondering if there was a way to list the value (Rather then sum it up) 

 

 

Ie:   SLAHours = Sum(sla[SLA Hours]) (this adds up the allocated hours together) 

 

is it possible to use something to list the data, like ALL, Datatable, etc? 

 

Thanks!