Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Problem with multiplying hours per pay rate

Hello! So I am working on a project and trying to mutliply employee hours by their pay rate based on pay grade but I seem to be having an issue. I've tried using SUMX * SUM but its giving me widly ma...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

     

    Sorry, it was complicated by me. Just try this:

     

    1. Create [Pay Measure 1].

     

    Pay Measure 1 = SUM( 'Hours'[Hours] ) * SUM ( 'PAY RATES'[Hrly Rate] )

     

     

    2. Create [Pay Measure 2].

     

    Pay Measure 2 = 
IF (
    HASONEVALUE ( Hours[Employee ID] ),
    [Pay Measure 1],
    SUMX ( Hours, [Pay Measure 1] )
)

     

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.