Forum Discussion

srkase's avatar
srkase
Icon for Helper IV rankHelper IV
7 years ago
Solved

CALCULATE PERCENTAGE

Hi    I have created a matrix table in the following manner   branch product spares %       chennai 10000 500 ?                         ? I want to create the perc...
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi srkase 

     

    Try this.

    % of Spares = 
VAR _products = CALCULATE(
    SUM( YourTable[TOTAL QTY] ), 
    YourTable[CATEGORY] = "PRODUCT"
)
VAR _spares = CALCULATE(
    SUM( YourTable[TOTAL QTY] ), 
    YourTable[CATEGORY] = "SPARES"
)
RETURN DIVIDE( _spares, _products )

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
7 years ago

Hi srkase 

 

Try this.

% of Spares = 
VAR _products = CALCULATE(
    SUM( YourTable[TOTAL QTY] ), 
    YourTable[CATEGORY] = "PRODUCT"
)
VAR _spares = CALCULATE(
    SUM( YourTable[TOTAL QTY] ), 
    YourTable[CATEGORY] = "SPARES"
)
RETURN DIVIDE( _spares, _products )

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

srkase's avatar
srkase
Icon for Helper IV rankHelper IV
7 years ago

thanks a lot..

 

I have added drill down also..  how to calculate the drill down percentage for unit-id?