Calculating Total Sales for a selected Product and its share based on customer you are evaluating

cdawidow — Thu, 24 Sep 2020 13:24:47 GMT

Hi guys, I want to calculate the sales amount of a customer given a specific product in comparison to the total sales of the company as a whole for that same product but I am having trouble with my calculations.

To get total sales of customer I just use a simple CUSTOMER SALES = CALCULATE(TOTAL SALES) which would be filtered when I select my customer and product.

But for total sales of that product should I use ALL or ALLSELECTED. CALCULATE(TOTAL SALES),ALL(TABLE),PRODUCT = ALLSELECTED(PRODUCT)) ???

Re: Calculating Total Sales for a selected Product and its share based on customer you are evaluating

Anonymous — Thu, 24 Sep 2020 13:49:50 GMT

// Assumptions: // Sales - fact table with sales // Customers - dimension that stores all customers // and joins to Sales on CustomerID. // Products - dimension that stores all prouducts // and joins to Sales on ProductID [Total Sales] = SUM( Sales[Amount] ) [Total Sales (All Custs)] = CALCULATE( [Total Sales], ALL( Customers ) )

topic Calculating Total Sales for a selected Product and its share based on customer you are evaluating in DAX Commands and Tips

Calculating Total Sales for a selected Product and its share based on customer you are evaluating

Re: Calculating Total Sales for a selected Product and its share based on customer you are evaluating