Forum Discussion

csb's avatar
csb
Frequent Visitor
1 year ago
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...
  • Shravan133's avatar
    1 year ago

    try this:

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

  • v-priyankata's avatar
    v-priyankata
    1 year ago

    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.