Forum Discussion

Babycakes's avatar
Babycakes
Helper II
3 years ago
Solved

Summing measure

Hi all,   I have been able to create a measure that tells me Hours above 76 (overtime) OT =SUM('DATA'[Hours]) - SUM('DATA[Hours per fn])   However I cannot sort this in my column bar as a total...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Babycakes ,

    Please have a try.

    Create a measure.

    Measure =
RANKX ( ALL ( 'Table' ), CALCULATE ( [neaOT x Overtime Rate] ),, DESC, DENSE )

    If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information.

     

    Best Regards

    Community Support Team _ Polly

     

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