We have developed a productivity scorecard that assigns a point value to each measure based on where the measure falls in the range. The measures are On Time & Close Rate; shown by employee with year and month slicers. Easy enough – We then take the point value and weight each at 50% to determine the composite score</SPAN></SPAN>
Example:</SPAN></SPAN>
On Time Close Rate </SPAN></SPAN>
Measure 93.90% 96.40%</SPAN></SPAN>
Points 75 150 </SPAN></SPAN>
Weight 0.5 0.5 </SPAN></SPAN>
Composite 112.5</SPAN></SPAN>
=if(ISBLANK(orglistSC[CR PTS]),orglistSC[CR PTS],orglistSC[CR PTS]*0.50)+if(ISBLANK(orglistSC[OT PTS]),orglistSC[OT PTS] ,orglistSC[OT PTS]*0.50)</SPAN></SPAN>
The issue is now they have asked us to weight the close rate at 100% for 1st quarter, and go back to 50/50 for the rest of the year.</SPAN></SPAN>
If I use =Calculate(if(ISBLANK(orglistSC[CR PTS]),orglistSC[CR PTS],orglistSC[CR PTS]*0.50)+if(ISBLANK(orglistSC[OT PTS]),orglistSC[OT PTS] ,orglistSC[OT PTS]*0.50),</SPAN> Dash_DateTbl[Quater]=1) </SPAN></SPAN>
Each month works via the slicer, but selecting multiple (Jan-June) does not work.</SPAN></SPAN>Any help would be appreciated.</SPAN></SPAN>
Example:</SPAN></SPAN>
On Time Close Rate </SPAN></SPAN>
Measure 93.90% 96.40%</SPAN></SPAN>
Points 75 150 </SPAN></SPAN>
Weight 0.5 0.5 </SPAN></SPAN>
Composite 112.5</SPAN></SPAN>
=if(ISBLANK(orglistSC[CR PTS]),orglistSC[CR PTS],orglistSC[CR PTS]*0.50)+if(ISBLANK(orglistSC[OT PTS]),orglistSC[OT PTS] ,orglistSC[OT PTS]*0.50)</SPAN></SPAN>
The issue is now they have asked us to weight the close rate at 100% for 1st quarter, and go back to 50/50 for the rest of the year.</SPAN></SPAN>
If I use =Calculate(if(ISBLANK(orglistSC[CR PTS]),orglistSC[CR PTS],orglistSC[CR PTS]*0.50)+if(ISBLANK(orglistSC[OT PTS]),orglistSC[OT PTS] ,orglistSC[OT PTS]*0.50),</SPAN> Dash_DateTbl[Quater]=1) </SPAN></SPAN>
Each month works via the slicer, but selecting multiple (Jan-June) does not work.</SPAN></SPAN>Any help would be appreciated.</SPAN></SPAN>