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
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 Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)