Forum Discussion
Solved
Summarize table
Hi friends, I want to create a calculated table using Summarize function which contains "Sales" and "Cost" measure. Sales = CALCULATE(SUM(F_Sales[NetSales]),
TREATAS(VALUES('D_Table'[year...
I realized that my sale and cost measure using TREATAS must use the same granularity to make it work.
Hello tracytran91
I hope below code works for you.
Summarize_table =
VAR SalesTable =
SUMMARIZE(
D_TABLE,
'D_Table'[year_month],
'D_Table'[customer_no],
"Sales",[Sales]
)
VAR CostTable =
SUMMARIZE(
D_TABLE,
'D_Table'[sup_code],
'D_Table'[year_month],
'D_Table'[Product],
"Cost",[Cost]
)
RETURN
UNION(SalesTable,CostTable)
Thank You.
Anonymous Thank for your reply.
I gave it a try and UNION function make the column Sales and Cost becomes a "sales" column. It is not my expectation.
Hello tracytran91
Could you please share the pbix file after removing the sensitive information?
Thank You.