Forum Discussion

trulynaveen's avatar
trulynaveen
Frequent Visitor
6 years ago
Solved

Subtotal Issue

Hi Everyone,   I'm not able to produce a subtotal in my report. Can anyone please help me to fix this?   Formulas I used here are as below:    JobActualHours = IF(HASONEVALUE('Budget Data'[Dep...
Show and Tell
Tips and Tricks
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi , trulynaveen 

    You need to do same  change in  your  measures .

    Take the measure JobActualHours as a  sample:

     

    JobActualHours = SUMX(FILTER('Jobs Data', 'Jobs Data'[NewJobClass] in FILTERS('Budget Data'[DeptName])),('Jobs Data'[JobHours]))

     

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

trulynaveen's avatar
trulynaveen
Frequent Visitor
6 years ago

Sorry this is not helpful. Appreciate your response!

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi , trulynaveen 

    You need to do same  change in  your  measures .

    Take the measure JobActualHours as a  sample:

     

    JobActualHours = SUMX(FILTER('Jobs Data', 'Jobs Data'[NewJobClass] in FILTERS('Budget Data'[DeptName])),('Jobs Data'[JobHours]))

     

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.