Forum Discussion
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 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.
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
3 Replies
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
Thanks man!!
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.
