Need Help, Question about divide() function

[hkrash0920]

I am using the divide function to determine the percentage of revenue needed to get to goal. The formula I am using is

"Revenue Needed % = Divide ([Revenue Needed], [Revenue Goal],0)"

Below is the result I am getting

Why am I getting 101% for both when the correct answer is 56% and 52%?

Thanks

[hkrash0920]

Thank you...Thank you...Thank you. It worked. I really appreciate it. You are the best. 🙂

[vanessafvg]

what is the dax code for your base measures?

[hkrash0920]

For Revenue Needed, it is Revenue Needed = [Revenue Goal] - [FY17 FYTD TER]

The FY17 FYTD TER and Revenue goal columns are number fields in the data file that are summarized.

I am new to Power BI so if this is not what you are looking for, please let me know.

[vanessafvg]

and the values are in the same table?

it looks like a relationship issue to me but i could be wrong.

[hkrash0920]

They are in the same table.

[vanessafvg]

i think the only way i could figure out the problem is if you posted the pbix.

The data types are all decimal yes?  or currency?

[hkrash0920]

I am unable to publish the pbix. The data type is currency.

[spuder]

@hkrash0920

is revenue needed a measure or calc. column?

And is this the whole table or are there any more information that "filter" the position in the table?

[hkrash0920]

It is a calc column. This is a only a portion of the table. The table probably has about 30 rows. It is not filtered by anything.

[spuder · Accepted solution]

And revenue needed % is calc. column as well? Must be otherwise it wouldn't work (row level context)

Could you try to write the % as a measure?

% as Measure = DIVIDE(SUM(test[Revenue Needed]);SUM(test[Revenue Goal]);0) 

In my little rebuildet table both worked.

[hkrash0920]

Thank you...Thank you...Thank you. It worked. I really appreciate it. You are the best.