FILTER same Data for multiple products

[Hemanttripathi]

Hello BI users,

Greetings!

I am a newbie in Power BI and looking for some help;

I have data consisting of multiple columns with users and product name as following example;

Branchmonth	Username	EmplID	Branch	product name	Total sales	salescount	Year	Month
XXXX	142365	123456	ABC	A	1	1	2019	1
				B	20	2	2018	2
				V	5	5	2015	3
				D	0	8	2015	3
				F	60	9	2018	4
				C	80	10	2019	1

My requirement is to create new table with all existing columns from data table and filter all data to get product A, B, C in filtered new table.

I tried following under modelling by selecting "New Table".

Table 3 = Filter( Sales, RELATED(Sales [product name])="A", "B", "C")

However, I am recievcing an error.

Data table name: Sales

Column to filter: product name

Product type: A, B, C.

Can someone please suggest.

Thanks you,

Regards,

Hemant

[Aree]

Hey Mate,

Have you tried 

Summarize

Your syntax might look like this

Table3  = Summarize(Sales, Sales'Product Name', <expression>)

You can use an expression to do a sum if you so desire or do not do any aggregation and just list "total sales".

[Hemanttripathi]

Hello Arre,

I will try as thats a next step, I was willing to do.

Regards,

Hemant

[HotChilli · Accepted solution]

Create a table using:

abcBranchSales = FILTER('Branch Sales', 'Branch Sales'[product name] in {"A", "B", "C"})