Forum Discussion

alanshake23's avatar
alanshake23
Regular Visitor
1 year ago
Solved

Problem with total values within a table

I have a problem with my report. After running some tests, I noticed that the coverage percentage is considering surplus personnel. When I checked the surplus measurement, it doesn't subtract the ass...
Show and Tell
Tips and Tricks
  • MohamedFowzan1's avatar
    MohamedFowzan1
    1 year ago

    Hi alanshake23 

     

    Try to have the surpluse logice within the measure.

     

    Coverage % =

    VAR Authorized = SUM('Table'[Autorizado])

    VAR Active = SUM('Table'[Activos])

    VAR Surplus = IF(Active > Authorized, Active - Authorized, 0)

    VAR AdjustedActive = Active - Surplus

    RETURN

    DIVIDE(AdjustedActive, Authorized)

     

    Please provide the expected output along with the screenshot if this doesnt work

MohamedFowzan1's avatar
MohamedFowzan1
Super User
1 year ago

Hi alanshake23 

 

Try to have the surpluse logice within the measure.

 

Coverage % =

VAR Authorized = SUM('Table'[Autorizado])

VAR Active = SUM('Table'[Activos])

VAR Surplus = IF(Active > Authorized, Active - Authorized, 0)

VAR AdjustedActive = Active - Surplus

RETURN

DIVIDE(AdjustedActive, Authorized)

 

Please provide the expected output along with the screenshot if this doesnt work

  • alanshake23's avatar
    alanshake23
    Regular Visitor
    1 year ago

    Thanks man!!