I think this is easy enough to achieve....
I have 3 Dimensions linking to a Sales Table. The Sales Table captures the Customer, Year, Market and Value of the Sale and the Dimensions represent the Customers, Years, and Markets associated with the Sales.
My 3 required measure are, Total Sales, Domestic Sales, Foreign Sales (Non Domestic), which have been written as follows:-
Total Sales:= CALCULATE(SUM(Sales[SalesAmount]))
Domestic Sales:= CALCULATE([Total Sales], FILTER('Market','Market'[Market]="Ireland"))
Foreign Sales:= CALCULATE([Total Sales], FILTER('Market','Market'[Market]<>"Ireland"))
This works fine until the report is sliced by Market which indicates only the Total Sale for a Market.
What I wish to produce are measures whereby Total Sales, Domestic Sales and Foreign Sales are not slice able other than my date ie at a summary level?
I've attached a spreadsheet with this example for ease of reference?
Any assistance would be greatly appreciated.