Percent Difference from Measure

[hanami001]

He Everyone,

I want to get percent difference from 2 columns, that is created from a measure.

For column: TS_%Diff from target, this is calculated the difference from column Rev Target and Rev Actual but the result is incorrect.

TS_%Diff from Target = DIVIDE([Revenue Cal] , [TS_Rev Target by %Rev Actual] , BLANK())

Please advise me on this problem.

Thank you!

[Floriankx]

What is your expected result?

[hanami001 · Accepted solution]

Hi Flotiankx,

Please ignore this problem, due to I have misunderstood on the calculation.

Thank you.