How to slice measure's value one table only

[ajve22]

Hi,

I have created a measure (Total Sales) in sales table of the model. This measures is displayig on the visual with 'Customers'[customer name] . Both the tables 'Customers' and 'Sales' have one-many relationship and the model has many other tables like 'Date', 'Products'.

The measure's values should be sliced by 'Customers' table only not by any other table. I am using this dax currently and working correctly:

Total Sales = Calculate(SUM('Sales'[sales amount]), ALL('Date'), ALL('Products'),.........)

As the model has many tables 20+ and adding these many tables in ALL doesn't look perfect.

Is there any other way in dax to acheive the same?

Thanks

[DataInsights · Accepted solution]

@ajve22,

Try this measure. It uses ALL with no arguments to clear all filters, and then restores the filters on Products.

Total Sales =
CALCULATE ( SUM ( 'Sales'[sales amount] ), ALL (), VALUES ( 'Products' ) )