Forum Discussion

rommel20's avatar
rommel20
Icon for Resolver I rankResolver I
8 years ago
Solved

Percentage within Percentage

Hi,   is there any way i can create Percentage withn Percentage for e.g   Group       Percentage Teacher      5% Engineer     90% Programmer 5%   if i selected teacher i will show the percen...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    rommel20

     

    According to your description, you want to calculate the percentage of parent when drilling down to child level. Right? 

     

    In this scenario, you have to specify different column as filter in CALCULATE(). It can be like: 

     

    % Value =
IF (
    HASONEVALUE ( Table[SubGroup] ),
    DIVIDE (
        SUM ( Tble[Value] ),
        CALCULATE ( SUM ( Table[Value] ), ALL ( Table[SubGroup] ) )
    ),
    DIVIDE (
        SUM ( Tble[Value] ),
        CALCULATE ( SUM ( Table[Value] ), ALL ( Table[Group] ) )
    )
)

    Please refer to article below: 

    PowerPivot: Calculate ratio to parent

     

    Regards,

     

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

rommel20

 

According to your description, you want to calculate the percentage of parent when drilling down to child level. Right? 

 

In this scenario, you have to specify different column as filter in CALCULATE(). It can be like: 

 

% Value =
IF (
    HASONEVALUE ( Table[SubGroup] ),
    DIVIDE (
        SUM ( Tble[Value] ),
        CALCULATE ( SUM ( Table[Value] ), ALL ( Table[SubGroup] ) )
    ),
    DIVIDE (
        SUM ( Tble[Value] ),
        CALCULATE ( SUM ( Table[Value] ), ALL ( Table[Group] ) )
    )
)

Please refer to article below: 

PowerPivot: Calculate ratio to parent

 

Regards,