cancel
Showing results for
Did you mean:
Resolver II

## Can't Compare Measure to a Column

Hello -

I have a COLUMN called "Tenure Efficiency Target" which is calculated based on an employee's tenure in the company.  The tenure is based on a hire date (also a calculated COLUMN).

Tenure in Months = DIVIDE((TODAY() - Report_Efficiency[Hire Date]),30)

I created 6 tenure buckets based on Tenure in Months and have assigned a Tenure Efficiency Target to each.

 Tenure Bucket Tenure Efficiency Target 0-3 mos 0.6 3-6 mos 0.75 6 mos-1 yr 0.85 1-2 yrs 0.95 2-3 yrs 1 3+ yrs 1

Employee Efficiency is a calculated measure based on several parameters, and I want to compare it to the Tenure Target.

I want to show in a table only the employees for whom Employee Efficiency < Tenure Target

The grain of the table is date, employee.  The records in the table represent jobs the employee has completed, and I calculated the Employee Efficiency based on certain parameters in the table for each employee.  It's a measure, as I said before.

Since the employee's efficiency is a MEASURE, and the TENURE TARGET is a COLUMN,  I can't do it.

Seems like an easy thing, but of course it's not!  Any suggestions?  Thanks.

1 ACCEPTED SOLUTION
Super User III

Hi,

To your visual, drag Tenure Bucket and write these measures

Measure 1 = sum(Data[Tenure efficiency bucket])

Target met = [EMployee efficiency]=[Measure 1]

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User III

Hi,

To your visual, drag Tenure Bucket and write these measures

Measure 1 = sum(Data[Tenure efficiency bucket])

Target met = [EMployee efficiency]=[Measure 1]

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com

Announcements

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.