ssas5部署与管理.rar

DEFINE MEASURE 'Internet Sales'[Internet Total Sales] = SUM('Internet Sales'[Sales Amount]) EVALUATE SUMMARIZECOLUMNS ( 'Date'[Calendar Year], TREATAS({2013, 2014, 2015}, 'Date'[Calendar Year]), "Total Sales", [Internet Total Sales], "Combined Years Total Sales", CALCULATE([Internet Total Sales], ALLSELECTED('Date'[Calendar Year])), "ABC", SUMX('Internet Sales', 'Internet Sales'[Sales Amount]) / CALCULATE(SUM('Internet Sales'[Sales Amount]), ALLSELECTED('Date'[Calendar Year])) ) ORDER BY [Calendar Year]