Forum Discussion
Babycakes
Helper II
Helper IISumming 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...
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.
Ashish_Mathur
Super User
Super UserHi,
Share some data and show the expected result.