Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 | State | Sales Amount |
India | Hyderabad | 150014 |
India | Delhi | 185405 |
India | Mumbai | 220796 |
US | Georgia | 125405 |
US | Mexico | 145405 |
US | New York | 165405 |
UK | England | 120245 |
UK | Scotland | 169875 |
UK | Ireland | 168472 |
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.
Thanks, I need % difference when compari to india total sales (like 20% High when compaired to India total sales)
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |