Forum Discussion
Solved
Percentage value at total row.
Hi, I am trying to write below DAX function to calculate the %Pallet Capacity metric as shown in screenshot.But the %Pallet Capacity value at Total row is showing incorrectly .The answer should be...
try this:
% Pallet Capacity =
DIVIDE(
SUM('Reporting v_CustomerInventoryActive'[activePallets]),
SUM('Reporting v_CustomerInventoryActive'[CustomerMaxPallets]),
0
)
Hi csb
Hope everything’s going smoothly on your end. We haven’t heard back from you, so I wanted to check if the issue got sorted. If yes, marking the solution would be awesome for others who might run into the same thing.
Shravan133
Super User
Super Usertry this:
% Pallet Capacity =
DIVIDE(
SUM('Reporting v_CustomerInventoryActive'[activePallets]),
SUM('Reporting v_CustomerInventoryActive'[CustomerMaxPallets]),
0
)