Help with calculating accumulative %

Hi Anonymous 

You can try changing the formula to the following.

% = DIVIDE([total tax], [income], 0)

Here is a simple test I did:

My sample:

Based on your screenshots, it looks like your total tax and total income are both measures, so I created two measures as well.

total tax = SUM('Table'[TAX])

total income = SUM('Table'[INCOME])

Output:

If the problem persists, please provide sample data and the expected result based on sample data so that I can better help you. How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show it as screenshots or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.