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

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]

 

  • 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

    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!