sum by group

Thank you Hamed. I don't think I provided enough information. As a result, that DAX statement does not quite provide me what I want.

So, oddly that works in one table visual, but not the other. In one visual, it displays a column that sums exactly as described (by Summary). However, in another table it displays the sum of all of the values. For example,

Table Visual 1 - This table uses only columns from the tablename table in the data view.

Table Visual 2 - This table uses only columns from a different table in the data view. Call it tablename2. When I enter the measure in this table it displays as follows. Selecting "Don't Summarize" results in an expanded table that lists every data element for the Hours column which is not what I want. 

What I want is this:

muelledg 

Not sure how you've considered the Index in your data. Please share details!
I just tried assuiming the data, it is better if you can share sample data and the measures you tried. 

muelledg 

Try this Dax!

HERTP =
SUMX(
VALUES(tablename[Summary]),
CALCULATE(SUM(tablename[Hours]))
)

hi muelledg ,

try to write a calculated column like:

HERTP =

SUMX(

    FILTER(

        tablename,

        tablename[Summary]=EARLIER(tablename[Summary])

            &&tablename[Index]<EARLIER(tablename[Index])

    ),

    tablename[hours]

)

Hi muelledg 

Agree with HamedM1125.

Please provide sample data that covers your problem.

I have performed a simple test using data based on currently known information. There is no need to use measures to achieve the result you want.

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