cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Measure not Totaling correctly in visualization

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

 

0 REPLIES 0

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors