cancel
Showing results for
Did you mean:
Highlighted
Anonymous
Not applicable

## Sum of a column with text filters

Hi,

I have got a table like this

 Land Group Type Value China A XY 10 Germany A ZU 21 USA B XY 15 Spain B ZU 16 China C XY 8 USA C XY 25 China A XY 20 Germany A ZU 15 USA B XY 3 Spain B XY 15 China C XY 8 USA C XY 20

Now I want to calculate the Sum the column Value which is grouped by Land, Group and type (for example). To get this:

 Land Group Type Sum Value China A XY 30 China C XY 16 Germany A ZU 36 Spain B ZU 16 Spain B XY 15 USA B XY 18 USA C XY 45

Any Ideas?

Best regards

Timo

1 ACCEPTED SOLUTION

Accepted Solutions
Super User I

## Re: Sum of a column with text filters

@Anonymous  Please try this as a "New Table"

`GroupingTestOut = SUMMARIZECOLUMNS(GroupingTest[Land],GroupingTest[Group],GroupingTest[Type],"Total Value",SUM(GroupingTest[Value]))`

Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !

5 REPLIES 5
Regular Visitor

## Re: Sum of a column with text filters

Hi,

Depending on what you want to achieve, this can be done with a simple matrix.

Add Land, Group, Type in Rows

Drill down and format as required.

Anonymous
Not applicable

## Re: Sum of a column with text filters

Hi @George1 ,

But I need it as a calculated column. I have to calculate some other values with this column.

BR

Timo

Super User I

## Re: Sum of a column with text filters

@Anonymous  Please try this as a "New Table"

`GroupingTestOut = SUMMARIZECOLUMNS(GroupingTest[Land],GroupingTest[Group],GroupingTest[Type],"Total Value",SUM(GroupingTest[Value]))`

Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !

Community Support Team

## Re: Sum of a column with text filters

Hi @Anonymous ,

You can create a calculated column like DAX below.

`Sum Value = CALCULATE(SUM('Table'[Value]),FILTER(ALLSELECTED('Table'),'Table'[Land]=EARLIER('Table'[Land])&&'Table'[Group]=EARLIER('Table'[Group])&&'Table'[Type]=EARLIER('Table'[Type])))`

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regular Visitor

## Re: Sum of a column with text filters

Try this:

```CalcTable =
SUMMARIZECOLUMNS (
Table1[Land],
Table1[Group],
Table1[Type],
"Sum Value", SUM ( Table1[Value] )
)```

Announcements

#### Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!