cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ConnieMaldonado
Resolver II
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 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.

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User III
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
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

1 REPLY 1
Ashish_Mathur
Super User III
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
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

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

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.