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.

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.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors