Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help with parameter

Hello, I have a report calculating how many hours an employee works.  It has a formula that like: SUM(Regular Hours) + SUM(Extra Hours) - Lunch Deduction.   I need to find out from the user what ...
Need Help
  • calerof's avatar
    calerof
    5 years ago

    Anonymous 

    With this code:

    WTF = 
SUMX(WTF, [Working Hours Total] - 'Lunch Hours'[Lunch Hours Value])

    See here:

    Half hour lunchOne hour lunch

    Works for me. Maybe you could share sample data and your pbix file.

    F

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I got it working.  What I did different...My Worked Hours was a Column, so I created it was a Measure (never know when to use column or measure), then I used the SUMX like you did and it worked. Thank you so much for your patience and help!

calerof's avatar
calerof
Impactful Individual
5 years ago

Good to hear. Rule of thumb: Always use measures, never use calculated columns. Unless it's completely necessary. 

😉

F