Forum Discussion

8125551478's avatar
8125551478
Frequent Visitor
3 years ago

Calculate % Difference

Hi, Kindly sugest the below problem statement.  calculate % Difference  with other countys (when compair total sales of india to other counters ,How much of % difference is coming )   Country ...
Need Help
rajulshah's avatar
rajulshah
Icon for Resident Rockstar rankResident Rockstar
3 years ago

8125551478 

 

Please try following:

% Difference = 
VAR Sales =
    SUM ( '% Difference'[Sales Amount] )
VAR TotalSales =
    CALCULATE (
        SUM ( '% Difference'[Sales Amount] ),
        ALL ( '% Difference'[Country] )
    )
RETURN
    DIVIDE ( Sales, TotalSales )

 

I am getting the following results.

Hope this helps.

8125551478's avatar
8125551478
Frequent Visitor
3 years ago

Thanks, I need % difference when compari to india total sales  (like 20% High when compaired to India total sales)