Forum Discussion
Help with calculating accumulative %
hello
I need help calculating a %.
The blue bar is the sum of several months of a company's total taxes paid and also I have the total of the income of the same months.
The percentage I want to calculate is how much that sum of months (say January, February, March, April) represents over the total income of that same month. use the formula
%overincome = SUMX(ZBAL,DIVIDE([total taxes],[income],0)). and it calculates it well for me, but it is calculated monthly, not accumulated. The error that is occurring is that it adds the % of total taxes/income. and the correct thing is to take the total taxes and divide it by income, not simply add the percentages from all months. What can be the DAX for this?
The correct answer would be 1.244.205 (total tax)/ 172.400.000 (total income) = 7,2%.. and the answer in my wrong PBI is 5.09 (the sum of all the % of the months)
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 XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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 XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.