Forum Discussion
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...
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
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.