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
Wise1's avatar
Wise1
Helper I
9 years ago

SLAHours = Sum(sla[SLA Hours]) 

- Problem is i cant add this up because the "SLA HOURS" is a set number which is set and differs (ie: some might be 10 hours, some 20) 

 

ie: Client A has - 10 hrs

     Client B has - 20 Hrs

 

When i sum it up- it just adds the "SLA Hours" up and gives me a number of 30 

 

 

 

 

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Wise1,

 

In addition, use the formula below to create a measure, and show it with the Client id on the report should also work.:smileyhappy:

SLAHrsCalculatedPerClient = SUMX ( sla, sla[MeasureTotalTimespentOrg] - sla[SLA Hours] )

Regards

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi Wise1,

     

    You can use the SUM function in DQ mode if you go to Options -> DirectQuery and enable "Allow unrestricted measures in DirectQuery mode".:smileyhappy:

     

     

     

    Regards

  • Wise1's avatar
    Wise1
    Helper I
    9 years ago

     

    Thanks for replying, it does not seem to work with the method above, but works when i do it with only lets say [SLA Hours]

     

  • Wise1's avatar
    Wise1
    Helper I
    9 years ago

    Just thought i would reply so people dont think i have forgotten about this thread

     

    Still trying to pull it together, but getting closer! thanks everyone for their input so far!