cancel
Showing results for
Did you mean:
Member

## 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

## Re: Sum of a column with text filters

@TimoRatz  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
Highlighted
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.

Member

## 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

## Re: Sum of a column with text filters

@TimoRatz  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 @TimoRatz ,

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

#### New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

#### November 2019 Community Highlights

Get an overview of the events and great community content from November.

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)