Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |