I have got a table like this
Now I want to calculate the Sum the column Value which is grouped by Land, Group and type (for example). To get this:
Go to Solution.
@TimoRatz Please try this as a "New Table"
GroupingTestOut = SUMMARIZECOLUMNS(GroupingTest[Land],GroupingTest[Group],GroupingTest[Type],"Total Value",SUM(GroupingTest[Value]))
Proud to be a Datanaut !
View solution in original post
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.
Hi @George1 ,
thanks for your reply.
But I need it as a calculated column. I have to calculate some other values with this column.
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])))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
"Sum Value", SUM ( Table1[Value] )
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!