Forum Discussion

Noel's avatar
Noel
Copper Contributor
Dec 05, 2017

MDX/ calculated measure issue

Hello all! I need some help with a MDX formula that I'm building in my cube. Its purpose is to sum the number of units sold by SKU. The SKUs start with SUP. If I want a count of one unit, it works, adding multiple SKUs does not. Anybody know the answer?

 

 

 

SUM([Dim SKU].[SKU].&[sup9640],[Measures].[Units])+SUM([Dim SKU].[SKU].&[sup9640],[Measures].[Units]) +SUM([Dim SKU].[SKU].&[sup9614],[Measures].[Units])+SUM([Dim SKU].[SKU].&[sup0118],[Measures].[Units])+SUM([Dim SKU].[SKU].&[sup9128],[Measures].[Units])+SUM([Dim SKU].[SKU].&[sup0212],[Measures].[Units])+SUM([Dim SKU].[SKU].&[sup0117],[Measures].[Units])+SUM([Dim SKU].[SKU].&[sup9615],[Measures].[Units])+SUM([Dim SKU].[SKU].&[sup0048],[Measures].[Units]) 

No RepliesBe the first to reply

Resources