Forum Discussion
Noel
Dec 05, 2017Copper Contributor
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