SSAS (Tabular)
2016. 9. 17.
DAX Query
MANY to MANY Product PRODUCT GROUP CD FMR Product Group PRODUCT_GROUP_CD PRODUCT_GROUP_CD TIME_SPENT_INSTORE_PLAN MANY MANY CALCULATE(SUM([TIME_SPENT_INSTORE_PLAN]), SUMMARIZE('Product', PRODUCT_GROUP_CD[PRODUCT_GROUP_CD])) HASONEFILTER & SWITCH IF( HASONEFILTER( Table2[Category] ) ,SWITCH( VALUES( Table2[Category] ) ,"CostPrice" ,[Cost] ,"SellingPrice" ,[Selling] ,"Profit" ,[Profit] ) ,[Profit]..
