Data:
Output:
How to Solve this problem!!
1 ACCEPTED SOLUTION
Hi @Chetan007
Try this:
DIVIDE (
SUM ( 'Table'[Value] ),
CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table'[Subgroup] ) )
)
That will look something like below:
If this doesn't work, please post a sample data that can be copy-pasted to Excel and not an image.
Hi @Chetan007
Try this:
DIVIDE (
SUM ( 'Table'[Value] ),
CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table'[Subgroup] ) )
)
That will look something like below:
If this doesn't work, please post a sample data that can be copy-pasted to Excel and not an image.
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
