Forum Discussion
Filter To specific Text in summarize
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
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
1 Reply
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