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

[cdawidow]

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)) ???

[Anonymous · Accepted solution]

// 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 )
)