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.
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.