Percentage value at total row.

[csb]

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 19297 ÷ 22750  = 0.84 which is 84%.

% Pallet Capacity = DIVIDE(sum('Reporting v_CustomerInventoryActive'[activePallets]),MAX('Reporting v_CustomerInventoryActive'[CustomerMaxPallets]),0)

How can I fix this ?

Thanks..

Thanks..

[v-priyankata]

Hi @csb 

May I ask if you have resolved this issue? @Shravan133 thanks for your inputs, @csb  please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Shravan133]

try this:

% Pallet Capacity =
DIVIDE(
SUM('Reporting v_CustomerInventoryActive'[activePallets]),
SUM('Reporting v_CustomerInventoryActive'[CustomerMaxPallets]),
0
)