cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TimoRatz Member
Member

Sum of a column with text filters

Hi,

 

I have got a table like this

LandGroupTypeValue
ChinaAXY10
GermanyAZU21
USABXY15
SpainBZU16
ChinaCXY8
USACXY25
ChinaAXY20
GermanyAZU15
USABXY3
SpainBXY15
ChinaCXY8
USACXY20

 

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

LandGroupTypeSum Value
ChinaAXY30
ChinaCXY16
GermanyAZU36
SpainBZU16
SpainBXY15
USABXY18
USACXY45

 

Any Ideas?

 

Best regards

Timo

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
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]))

image.png



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

Proud to be a Datanaut !





View solution in original post

5 REPLIES 5
Highlighted
George1 Regular Visitor
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

Add Value in Values

 

Drill down and format as required.

TimoRatz Member
Member

Re: Sum of a column with text filters

Hi @George1 ,

 

thanks for your reply.

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

 

BR

Timo

Super User
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]))

image.png



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

Proud to be a Datanaut !





View solution in original post

Community Support Team
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])))

38.png

 

 

 

 

 

 

Best Regards,

Amy

 

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

 

George1 Regular Visitor
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] )
)

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

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

November 2019 Community Highlights

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

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)