Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ConnieMaldonado
Responsive Resident
Responsive Resident

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
Super User

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
Super User

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/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.