topic Create a subset table from a fact table in DAX Commands and Tips

Create a subset table from a fact table

khaledSA — Fri, 15 May 2020 15:02:07 GMT

I need to creat a sub set table with all the columns in the main table but filtered with value "A" in the Code column. I need all related rows in the coulmns to be able to add additional calculated columns in the filtered sub set table. I appreciate your help.

Date	Code	Ind	Val
1/1/2020	A	NM	20
1/6/2020	B	BL	40
1/20/2020	A	NM	60
2/15/2020	A	CX	80
1/5/2020	C	DG	30

New table:

Date	Code	Ind	Val
1/1/2020	A	NM	20
1/20/2020	A	NM	60
2/15/2020	A	CX	80

Re: Create a subset table from a fact table

camargos88 — Fri, 15 May 2020 15:05:22 GMT

khaledSA ,

TABLE = FILTER(TABLE, TABLE[CODE] = "A")

Re: Create a subset table from a fact table

khaledSA — Fri, 15 May 2020 15:09:29 GMT

Hi Recardo,

I have tried that befroe but I get empty columns.

Re: Create a subset table from a fact table

camargos88 — Fri, 15 May 2020 15:10:53 GMT

khaledSA ,

Can you an example of it ?

Maybe your column needs to be cleaned. Have you tried TRIM/CLEAN it on Query Editor ?

Re: Create a subset table from a fact table

khaledSA — Fri, 15 May 2020 15:16:23 GMT

Worked after Trim/Clean. Thank you.