Forum Discussion

ConnieMaldonado's avatar
ConnieMaldonado
Icon for Responsive Resident rankResponsive Resident
5 years ago
Solved

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 BucketTenure Efficiency Target
0-3 mos0.6
3-6 mos   0.75
6 mos-1 yr0.85
1-2 yrs0.95
2-3 yrs1
3+ yrs1

 

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.

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    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.

1 Reply

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    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.