Forum Discussion
Summing measure
Hi all,
I have been able to create a measure that tells me Hours above 76 (overtime)
| Region | Staff member/s | Hours | OT | OT x Overtime Rate |
| VIC | SMITH Bob | 102.5 | 26.5 | $2,120 |
| QLD | JONES Lisa | 88 | 12 | $960 |
| QLD | SIMPSON John | 87 | 11 | $880 |
| NSW | BAKER Jill | 80.5 | 4.5 | $360 |
| TAS | CRAIG Tom | 79 | 3 | $240 |
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.
4 Replies
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.
Thank you, the table displayed is a visual that I am trying to get the measures to correct
Hi,
Share some data and show the expected result.
