Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 percentage based on Group Percentage
Subgroup Percentage
Math Teacher 3%
English Teacher 1.5%
Science Teacher 1.5%
I used this first formula in Group
% Value = DIVIDE(SUM(Value),CALCULATE(SUM(Value]),ALL(Group)))
Solved! Go to Solution.
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,
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,
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |