topic Re: Incorrect Achievement & Growth Percentage in DAX Commands and Tips

Incorrect Achievement & Growth Percentage

proavinash — Mon, 10 Feb 2025 15:54:02 GMT

there are 2 table table first is correct and 2nd is showing incorrect result when calculation in power bi i am using below dax formula

%'Ach'Jan25 = IFERROR(RCHGTarget[Ach_Jan25]/RCHGTarget[Jan'25],0)

%'Grth'Jan = IFERROR(RCHGTarget[Ach_Jan25]/RCHGTarget[Ach_Jan24]-1,0)

Ach_Jan25 = IFERROR(CALCULATE(SUM(SaleDump[Value_MN]),FILTER(SaleDump,SaleDump[Concat]=RCHGTarget[Concatch] && SaleDump[Year]="2025" && SaleDump[Month]="Jan" && SaleDump[Spill over]="No")),0)

Ach_Jan24 = IFERROR(CALCULATE(SUM(SaleDump[Value_MN]),FILTER(SaleDump,SaleDump[Concat]=RCHGTarget[Concatch] && SaleDump[Year]="2024" && SaleDump[Month]="Jan" && SaleDump[Spill over]="No")),0)

Re: Incorrect Achievement & Growth Percentage

Anonymous — Tue, 11 Feb 2025 03:17:59 GMT

Hi, proavinash
Thanks for reaching out to the Microsoft fabric community forum.

Regarding the issue you raised, my solution is as follows:

The main reason for the issue is that the calculated column automatically uses the SUM aggregation method, and there is a particular column used as a filter in the visual object. This filter in the visual object does not meet our requirements. As shown in my test data, the calculated results do not meet our needs:

You can try the following three solutions:

1.Use the following calculated column and change the aggregation method to MAX:

Column = DIVIDE ( CALCULATE ( SUM ( 'RCHGTarget'[Ach_Jan251] ), ALLEXCEPT ( 'RCHGTarget', 'RCHGTarget'[PARTICULAR] ) ), CALCULATE ( SUM ( 'RCHGTarget'[Jan'25] ), ALLEXCEPT ( 'RCHGTarget', 'RCHGTarget'[PARTICULAR] ) ) )

2.Use visual object calculations:

However, this can only be used for that specific visual object and cannot be called later.

3.Use the following measure:

Measure = DIVIDE(SUM(RCHGTarget[Ach_Jan251]),SUM('RCHGTarget'[Jan'25]))

This solution is the most effective, as the measure depends on context changes.

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

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

Re: Incorrect Achievement & Growth Percentage

proavinash — Wed, 12 Feb 2025 16:40:23 GMT

Thanks to reply, but not working as i want , please don't considere it as negative , please understand my problem

i have 2 table , 1 is Salesdump, and other is RCHGTarget,

Salesdump table has all dump related fileds including sales value and quantity,

and Target table has Target,

how i formulation of tracking,

i prepare a unique filed in both table by concatinate, Channel-Region-Zone etc. like below example.

Concatch

Domestic-Project-COMM-North-NCR

Domestic-Project-COMM-North-RAJASTHAN

Domestic-Project-COMM-North-UP East

Domestic-Project-COMM-North-UP NORTH

Domestic-Project-COMM-North-Up West & Uk

Domestic-Project-COMM-East-JOB

Domestic-Project-COMM-East-NE

Domestic-Project-COMM-East-WB

in which target already inbuilt not formulated , and sales achievement is formulated as give in formula

and after this i have applied this in matrix , and achievement % , and growth % by calculation seperatly as given above formula.

so the indivial ach % & growth % near about correct but total not correct.

full table below.

Re: Incorrect Achievement & Growth Percentage

proavinash — Thu, 13 Feb 2025 10:18:12 GMT

after deep study with you solution i found its working , when used you pbix file as referenece.

Re: Incorrect Achievement & Growth Percentage

Anonymous — Thu, 20 Feb 2025 02:19:47 GMT

Hi, proavinash
I am glad that my answer could help you, and I appreciate you accepting my answer as the solution. This recognition of my efforts also helps others in the community with similar issues find solutions more quickly.

If you encounter any problems in the future, feel free to share them again.

Have a great day!

Best Regards,

Leroy Lu