Percentage not reflected correctly

[Lolo_2023]

Hi experts,

I have question related to the calculation of percentage in power bi , i have this data on excel that says the total of the all percentage is 100 %

, but when i try to represent it on power bi it’s doesn’t reflect correctly.

How can i fix this problem

I’ve used this Dax to calculate percentage :

PER% =

Var a = sum(‘Table1’[column1])

Var b = sum(‘Table1’[column2])

Return

DIVIDE(a,b,0)

 

 

[BeaBF · Accepted solution]

@Lolo_2023 Hi! Can you paste the data of Column1 and Column2?

You can try with Sumx in a measure:

PER% =
SUMX('Table1', DIVIDE('Table1'[column1], 'Table1'[column2], 0))

or try to use a ROUND:
PER% = ROUND(DIVIDE(SUM('Table1'[column1]), SUM('Table1'[column2]), 0), 4)

BBF

[v-pnaroju-msft · Accepted solution]

Thank you, @BeaBF , for your response.

Hi @Lolo_2023 ,

We appreciate your inquiry on the Microsoft Fabric Community Forum.

The difference is likely due to rounding variations and the way Power BI aggregates individual percentages. When individual percentages are displayed along with a total, Power BI may sum the displayed percentages, which are already rounded. As a result, the total may slightly deviate from 100% due to the accumulation of rounding errors.

Please find the attached PBIX file for your reference, which may assist in resolving the issue.

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.

Thank you.

[v-pnaroju-msft]

Hi Lolo_2023,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank you.

[v-pnaroju-msft]

Hi Lolo_2023,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

[techies · Accepted solution]

Hi @Lolo_2023  

PER% =
VAR a = SUM('Table1'[column1])
VAR b = SUM('Table1'[column2])

RETURN
FORMAT(DIVIDE(a, b), "0%")

[v-pnaroju-msft]

Hi Lolo_2023,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank you.

[v-pnaroju-msft · Accepted solution]

Thank you, @BeaBF , for your response.

Hi @Lolo_2023 ,

We appreciate your inquiry on the Microsoft Fabric Community Forum.

The difference is likely due to rounding variations and the way Power BI aggregates individual percentages. When individual percentages are displayed along with a total, Power BI may sum the displayed percentages, which are already rounded. As a result, the total may slightly deviate from 100% due to the accumulation of rounding errors.

Please find the attached PBIX file for your reference, which may assist in resolving the issue.

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.

Thank you.

[BeaBF · Accepted solution]

@Lolo_2023 Hi! Can you paste the data of Column1 and Column2?

You can try with Sumx in a measure:

PER% =
SUMX('Table1', DIVIDE('Table1'[column1], 'Table1'[column2], 0))

or try to use a ROUND:
PER% = ROUND(DIVIDE(SUM('Table1'[column1]), SUM('Table1'[column2]), 0), 4)

BBF