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

[Shravan133 · Accepted solution]

try this:

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

[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.

[v-priyankata]

Hi @csb 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. we’ll be happy to assist.

[v-priyankata · Accepted solution]

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 · Accepted solution]

try this:

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