Can't Compare Measure to a Column

[ConnieMaldonado]

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.

[Ashish_Mathur · Accepted solution]

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.