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

[dwallerius]

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?

[Deku · Accepted solution]

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
)

[dwallerius]

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

[techies]

Hi @dwallerius please try this

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

[dwallerius]

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

[bhanu_gautam]

@dwallerius 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

[dwallerius]

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.