Creating a calculated table

[Anonymous]

I have created a table with the following code:

Tabela de Apoio =
SUMMARIZE (
Pedidos;Pedidos[Dia].[Date];Pedidos[Dia da Semana];Pedidos[Número dia da semana];
"Unidades Pedidas"; SUM(Pedidos[REQUESTED_UNIT_QTY] );"Pedidos";COUNT(Pedidos[DISTRO_NBR]);"SKUs diferentes";DISTINCTCOUNT(Pedidos[ITEM_ID]);"Un./Ped."; SUM(Pedidos[REQUESTED_UNIT_QTY])/COUNT(Pedidos[DISTRO_NBR]);"Un./SKU";SUM(Pedidos[REQUESTED_UNIT_QTY])/DISTINCTCOUNT(Pedidos[ITEM_ID]);"Ped./SKU";COUNT(Pedidos[DISTRO_NBR])/DISTINCTCOUNT(Pedidos[ITEM_ID])
)

I am analysing the Un./SKU indicator by day but I want to filter the table results with some other columns from item_master and Pedidos to make different analyses, for example ITEM_MASTER[dept_name]. I don't want to get the disaggregated results by adding ITEM_MASTER[dept_name] to the table

[v-sihou-msft]

@Anonymous

How did you build relationship between ITEM_MASTER and Pedidos?

If you want to aggregate data on "ITEM_MASTER[dept_name]" level, you must have relationship between ITEM_MASTER and this calculated table, which means you should have common column ("ITEM_MASTER[dept_name]") in both tables.

Regards,