topic DAX Formula to capture Total Sales vs. Target Goal to get % Achieved in DAX Commands and Tips

DAX Formula to capture Total Sales vs. Target Goal to get % Achieved

Anonymous — Fri, 14 Mar 2025 13:15:01 GMT

Help! I am trying to get the % of Goal Achieved, but the result of my calculation is giving me a whacked out %. What is causing this?

Re: DAX Formula to capture Total Sales vs. Target Goal to get % Achieved

bhanu_gautam — Fri, 14 Mar 2025 13:18:12 GMT

Anonymous To calculate the percentage of goal achieved for each row, you can use calculated column instead of a measure

% Achieved = DIVIDE('System Users'[Total Est. Share], 'System Users'[Target], 0) * 100

If you want to use a measure, ensure that the context is correctly set. Here’s a revised measure that should work correctly in a table or matrix visualization:

% Achieved =
VAR TotalEstShare = SUM('System Users'[Total Est. Share])
VAR Target = SUM('System Users'[Target])
RETURN DIVIDE(TotalEstShare, Target, 0) * 100

Re: DAX Formula to capture Total Sales vs. Target Goal to get % Achieved

Anonymous — Fri, 14 Mar 2025 17:02:48 GMT

Unfortunately, this gave me the same exact result. It produces 3400% for each person.

Could this be a relationship issue? I did bring over the estimated share and target columns from other tables.

Re: DAX Formula to capture Total Sales vs. Target Goal to get % Achieved

techies — Fri, 14 Mar 2025 17:16:46 GMT

Hi Anonymous please try this

% Achieved =
SUMX(
'System Users',
DIVIDE('System Users'[Total Est. Share], 'System Users'[Target], 0) * 100
)

Re: DAX Formula to capture Total Sales vs. Target Goal to get % Achieved

Anonymous — Fri, 14 Mar 2025 18:06:26 GMT

Unfortunately, that didn't work either. Different result, but still wacked.

Re: DAX Formula to capture Total Sales vs. Target Goal to get % Achieved

Deku — Fri, 14 Mar 2025 22:21:18 GMT

What is the measurement you are try to made, it is not clear? Your % are massive because you * 100.

This?

DIVIDE( 'System Users'[Total Est Share], 'System Users'[Target] ,0 )

Or are you looking for the overall % achieved

DIVIDE( sum( 'System Users'[Total Est Share] ), sum ('System Users'[Target] ) ,0 )

Re: DAX Formula to capture Total Sales vs. Target Goal to get % Achieved

Anonymous — Mon, 17 Mar 2025 12:09:45 GMT

Thank you, I actually figured it out on Friday. I had to change it from % to whole number.