Forum Discussion
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 19297 ÷ 22750 = 0.84 which is 84%.
How can I fix this ?
Thanks..
Thanks..
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.
4 Replies
try this:
% Pallet Capacity =
DIVIDE(
SUM('Reporting v_CustomerInventoryActive'[activePallets]),
SUM('Reporting v_CustomerInventoryActive'[CustomerMaxPallets]),
0
)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.
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.
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.