DAX measure for calculating potential revenue
Hi all, I am currently working on a report comparing revenue between the same product but with different sales environments. I want to work out the average revenue lost per item and total average overall revenue lost from the one in the worser performing environment, based on the sales in the better performing environment. I have the total quanity of sales for both categories and total revenue for both. Is there any measures that could help me with this? Thanks!
DAX for Sum and Average on category level
Hello Community, I have below Sales metric data source in one database table: Metric Name City Name Target Actual Time Period New Clients New York 25% 15% Jan-20 New Clients New York 25% 10% Feb-20 New Clients New York 25% 10% Mar-20 New Clients Boston 25% 20% Jan-20 New Clients Boston 25% 30% Feb-20 New Clients Boston 25% 35% Mar-20 Returning Clients New York 40% 55% Jan-20 Returning Clients New York 40% 35% Feb-20 Returning Clients New York 40% 40% Mar-20 Returning Clients Boston 40% 35% Jan-20 Returning Clients Boston 40% 25% Feb-20 Returning Clients Boston 40% 60% Mar-20 I am trying to achieve the below result in Matrix Visual which shows totals for the rows but Average for the Metric Name category: Metric Name Target City Name Jan-20 Feb-20 Mar-20 New Clients 25% New York 15% 10% 10% Boston 20% 30% 35% Average 18% 20% 23% Returning Clients 40% New York 55% 35% 40% Boston 35% 25% 60% Average 45% 30% 50% In matrix visual I find it challenging to have the first two columns and also having average as a sub-total but sum as a total for cities. Any guidance will be appreciated. Thanks, Jay
RankX not correct with measure for average sales
I am trying to RankX the regional manager of each team; however, manager have different size teams and hence higher sales. What I am trying to do is average out their sales / headcount and rank that; however, I am running into several spots when filtering by the month that some of the rankings are out of order, see pics. Any help is much appreciated.
