Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
4 years ago
Solved

percentage

Dear all

 

there is something I am doing incorrectly in the measure, which is yielding the wrong result, below is the formula I have used

all results are coming 100% and above

Not sure what is it I am doing incorrectly

I am trying to show what % of the hours are charged for a particular service line(using a line graph), in this case, its GCR of the total hours on a monthly basis

 

GCR% =
DIVIDE(
SUM('ECH MoM'[Actual] ),
CALCULATE(
SUM('ECH MoM'[Actual]),
ALLSELECTED('ECH MoM'[Actual]),
'ECH MoM'[Eng SSL Mapped1]="GCR"
)
)

 

 

Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    4 years ago

    vjnvinod , Try like

     


    GCR% =
    calculate( DIVIDE(
    SUM('ECH MoM'[Actual] ),
    CALCULATE(
    SUM('ECH MoM'[Actual]),
    ALLSELECTED('ECH MoM'[Actual])
    )
    ), filter('ECH MoM', 'ECH MoM'[Eng SSL Mapped1]="GCR"))

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    vjnvinod , Try like

     


    GCR% =
    calculate( DIVIDE(
    SUM('ECH MoM'[Actual] ),
    CALCULATE(
    SUM('ECH MoM'[Actual]),
    ALLSELECTED('ECH MoM'[Actual])
    )
    ), filter('ECH MoM', 'ECH MoM'[Eng SSL Mapped1]="GCR"))