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))
))))))))
