Filter To specific Text in summarize

[Anonymous]

How can i summarize a table column that contains text that i want to filter out?

example

Name

A

B

C

D

So i want to summarize to only show A and B 

[Shaurya · Accepted solution]

Hi @Anonymous,

Instead of using just the table name in the first parameter of Summarize, you can use a filtered table like:

New Table = SUMMARIZE(FILTER('Table','Table'[Name]="A" || 'Table'[Name]="B"),'Table'[Name],"Sum",SUM('Table'[Value]))

Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Graphical Comparison