Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All, I'm new to posting so I hope this is the correct place. I have a measure that calculates the FTE's (Full Time Equivalents) for companys working on site. I was asked to make certain companys a static number (override the calculation), I've achived that with the attached measure, but the Total is incorrect now. The Total is using the calculation and not the static number that shows up in the rows (attached .jpg) of the visualization. I've tried sumx, calculate, and several different ways I've seen posted but with no luck. Any help would be greatly appreciated!
Standard FTE Calc =
IF(
FIRSTNONBLANK('Company Type 1'[Company],1)="COMP1",
VALUE("27"),
IF(
FIRSTNONBLANK('Company Type 1'[Company],1)="COMP2",
VALUE("57"),
IF(
FIRSTNONBLANK('Company Type 1'[Company],1)="COMP3",
VALUE("15"),
IF(
FIRSTNONBLANK('Company Type 1'[Company],1)="COMP4",
VALUE("58"),
IF(
FIRSTNONBLANK('Company Type 1'[Company],1)="COMP5",
VALUE("5"),
IF(
FIRSTNONBLANK('Company Type 1'[Company],1)="COMP6",
VALUE("32"),
IF(
FIRSTNONBLANK('Company Type 1'[Company],1)="COMP7",
VALUE("7"),
IF(
FIRSTNONBLANK('Company Type 1'[Company],1)="COMP8",
VALUE("9"),
VAR Numerator=SUM(_CVXvw_CRISA_TimesheetDetail[time_on_site])
VAR Denominator=SUM('Calendar'[FTE Denominator])
RETURN
CALCULATE(DIVIDE(Numerator,Denominator))
))))))))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.