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 like to exclude total cost for items where the item manufacturer is blank. But it's been a while since I used MDX and I can't figure out the right syntax to exclude them. Something along the lines of
=CUBEVALUE("ThisWorkbookDataModel","[Daily].[Warehouse].[Phoenix]","NonEmpty([Item Master File].[Manufacturer Name])","[Measures].[Total Cost]")
Can someone help with the correct syntax? Thanks very much.
=CUBEVALUE("ThisWorkbookDataModel","[Daily].[Warehouse].[Phoenix]","[Measures].[Total Cost]")
However I would like to exclude total cost for items where the item manufacturer is blank. But it's been a while since I used MDX and I can't figure out the right syntax to exclude them. Something along the lines of
=CUBEVALUE("ThisWorkbookDataModel","[Daily].[Warehouse].[Phoenix]","NonEmpty([Item Master File].[Manufacturer Name])","[Measures].[Total Cost]")
Can someone help with the correct syntax? Thanks very much.