Quick measure : percentage different

[CookieNamtarn]

Hello, everybody.

i try to calculate different between vaule1 and value2 for calculate percentage from value2 from example

i use quick measure : percentage different

Item	Value1 : [Actual Output]	Value2 : [STD Output]	%different
1	0.85	0.855	-0.07%
2	2.06	0.855	141.24%
3	4.59	3.846	19.39%
AVG	2.50	1.852	35.14%

% difference =

VAR __BASELINE_VALUE = AVERAGE([STD Output])

VAR __VALUE_TO_COMPARE = AVERAGE([Actual Output])

RETURN

    IF(

        NOT ISBLANK(__VALUE_TO_COMPARE),

        DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)

    )

when i use excel to calculate same data but %Different data of Item1,2,3 and average is not same in Power BI.

Item	Value1 : [Actual Output]	Value2 : [STD Output]	%different
1	0.85	0.855	-0.58%
2	2.06	0.855	140.94%
3	4.59	3.846	19.34%
AVG	2.50	1.85	34.99%

I think it some a little different (decimal 2 digit) but i want to know why in power bi calculate don't same in calculator, what i misunderstand?

Thank you in advance.

[Anonymous]

Hi @CookieNamtarn ,

Please try this measure.

% difference =  [Actual Output] - [STD Output]	

Quick measure is calculating the rate of change, but it seems that you only want change.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum