I have the following "Scale" parameter table with 2 columns:
<tbody>
</tbody>
Following is a sample "OT Data" table
<tbody>
</tbody>
This is my attempt to create a DAX formula that when a slicer is selected such as >=75, the pivot table should show 2 instances (Mathew & Joseph) with total:170 OT Hours Worked:
ScaledOTWorked:=IF(HASONEVALUE(Scale[Value]),.......................... I only got this far. Please help
Thanks!!!!
Overtime Hours Worked | Value |
<25 | 24 |
>=25 | 25 |
>=50 | 50 |
>=75 | 75 |
<tbody>
</tbody>
Following is a sample "OT Data" table
Employee | OT Hours Worked |
John | 30 |
Mark | 60 |
Luke | 70 |
Mathew | 80 |
Joseph | 90 |
<tbody>
</tbody>
This is my attempt to create a DAX formula that when a slicer is selected such as >=75, the pivot table should show 2 instances (Mathew & Joseph) with total:170 OT Hours Worked:
ScaledOTWorked:=IF(HASONEVALUE(Scale[Value]),.......................... I only got this far. Please help
Thanks!!!!