I have a CUBEVALUE function that works fine for providing a total cost measure for items shipped from a warehouse (Phoenix in the sample below) in a dashboard. Simplified version is:
=CUBEVALUE("ThisWorkbookDataModel","[Daily].[Warehouse].[Phoenix]","[Measures].[Total Cost]")
However I would...