Problem with total values within a table

[alanshake23]

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 assets that are considered surplus. The way it works is as follows:

If active personnel > authorized personnel, then it displays the result of the subtraction between authorized personnel and active personnel. Otherwise, it displays 0.

Can I share the PBIX

Heres an example: Apparently the surplus formula only works in the rows but not in the column totals.

[V-yubandi-msft]

Hi @alanshake23 ,

I’ve updated the surplus and coverage logic so it now functions correctly for both individual rows and the totals. The calculations should now match your expectations, particularly regarding surplus personnel.

FYI:

The PBIX file is attached for your review. If you notice anything unusual or need further adjustments, please let me know.

Regards,

Yugandhar.

[MohamedFowzan1 · Accepted solution]

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]

Thanks man!!