Forum Discussion
Chart Display for Non-OT and OT values
Hi Experts, I have this table that has 3 columns: 1. Normal Hours 2. OT Hours 3. Employee Name I would need to calculate segregate the hours to display in the chart. How do i display both ...
amitchandak
Super User
Super Userwinniexlee , You need measures like
Sum(Table[Normal Hours])
Sum(Table[OT Hours])
OT Pay = SumX(Table, Switch(True() ,
Employee[Type]="A", [OT Hours] *2.5,
[OT Hours] *1.5
) * [Hourly Pay])
Ratio = divide(Sum(Table[OT Hours]) , Sum(Table[Normal Hours]) )
Change as per need
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.