Achievement % is fine per Region, but Grand Total is wrong

[Mohit_009]

Why is my Achievement % measure showing correct values at the Region level, but giving a strange or unexpected result in the Grand Total in Power BI? I was expecting the total to be based on the sum of the individual row values, but it looks like Power BI is recalculating it in the overall total context

Achievement % = DIVIDE([Sales Amount], [Target Amount])

[v-sshirivolu]

Hi @Mohit_009 ,

I would take a moment to thank @Jai-Rathinavel , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions

[v-sshirivolu]

Hi @Mohit_009 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

[cengizhanarslan]

The Grand Total is not the sum/average of the visible row percentages, your measure is being recalculated in the total filter context.

If you genuinely want the grand total to be the sum of the region-level percentages(but probably AVERAGEX would be a better option):

Achievement % =
SUMX(
    VALUES(Region[Region]),
    DIVIDE([Sales Amount], [Target Amount])
)

[Jai-Rathinavel · Accepted solution]

@Mohit_009 , I can see the post is duplicated providing you the correct DAX in both the threads. 

Please try the below DAX and check if the grand total issue is fixed.

Achievement% (New)= DIVIDE(
    SUMX(VALUES(DimRegion[Region]), [Sales Amount]),
    SUMX(VALUES(DimRegion[Region]), [Target Amount]))