I have the following "Scale" parameter table with 2 columns:
[TABLE="class: cms_table_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: cms_table_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: cms_table_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: cms_table_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!!!!