I have the following "Scale" parameter table with 2 columns:
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]Overtime Hours Worked
[/TD]
[TD]Value
[/TD]
[/TR]
[TR]
[TD]<25
[/TD]
[TD]24
[/TD]
[/TR]
[TR]
[TD]>=25
[/TD]
[TD]25
[/TD]
[/TR]
[TR]
[TD]>=50
[/TD]
[TD]50
[/TD]
[/TR]
[TR]
[TD]>=75
[/TD]
[TD]75
[/TD]
[/TR]
</tbody>[/TABLE]
Following is a sample "OT Data" table
[TABLE="class: grid, width: 200, align: left"]
<tbody>[TR]
[TD]Employee
[/TD]
[TD]OT Hours Worked
[/TD]
[/TR]
[TR]
[TD]John
[/TD]
[TD="align: center"]30
[/TD]
[/TR]
[TR]
[TD]Mark
[/TD]
[TD="align: center"]60
[/TD]
[/TR]
[TR]
[TD]Luke
[/TD]
[TD="align: center"]70
[/TD]
[/TR]
[TR]
[TD]Mathew
[/TD]
[TD="align: center"]80
[/TD]
[/TR]
[TR]
[TD]Joseph
[/TD]
[TD="align: center"]90
[/TD]
[/TR]
</tbody>[/TABLE]
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!!!!
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]Overtime Hours Worked
[/TD]
[TD]Value
[/TD]
[/TR]
[TR]
[TD]<25
[/TD]
[TD]24
[/TD]
[/TR]
[TR]
[TD]>=25
[/TD]
[TD]25
[/TD]
[/TR]
[TR]
[TD]>=50
[/TD]
[TD]50
[/TD]
[/TR]
[TR]
[TD]>=75
[/TD]
[TD]75
[/TD]
[/TR]
</tbody>[/TABLE]
Following is a sample "OT Data" table
[TABLE="class: grid, width: 200, align: left"]
<tbody>[TR]
[TD]Employee
[/TD]
[TD]OT Hours Worked
[/TD]
[/TR]
[TR]
[TD]John
[/TD]
[TD="align: center"]30
[/TD]
[/TR]
[TR]
[TD]Mark
[/TD]
[TD="align: center"]60
[/TD]
[/TR]
[TR]
[TD]Luke
[/TD]
[TD="align: center"]70
[/TD]
[/TR]
[TR]
[TD]Mathew
[/TD]
[TD="align: center"]80
[/TD]
[/TR]
[TR]
[TD]Joseph
[/TD]
[TD="align: center"]90
[/TD]
[/TR]
</tbody>[/TABLE]
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!!!!