How to create a filtered table

Hi,

If I understand correctly you want a uique list for the columns Type, Formula and Brand? 

I cannot reach your dataset because it is on your SharePoint.. also the url can be seen maybe good to know.

Based on this "Big table".

Try this formule:

SmallerBigTable = 
SUMMARIZE(
	BigTable;
	BigTable[Type];
	BigTable[Formula];
	BigTable[Brand]
)

Result:

If your goal is to get the distinct columns you can also use Power Query, select the columns and choose "Remove duplicates".

My above example is a New Table based on a DAX expression. This comes handy when you also when to do a calculation for this table. Doing that it is suggested to use ADDCOLUMNS instread of doing the calculation in the SUMMARIZE function.

Example:

SmallerBigTable =
ADDCOLUMNS (
    SUMMARIZE ( BigTable; BigTable[Type]; BigTable[Formula]; BigTable[Brand] );
    "Count of rows"; COUNTA ( BigTable[A] )
)

Hope this helps!

hidenseek9,

Try this:

SmallerBigTable = 
SUMMARIZE(
	FILTER(
		BigTable;
		BigTable[Type]="A"
		);
	BigTable[Type];
	BigTable[Formula];
	BigTable[Brand]
)