How to Sum a min measure

[Mark_Timson]

Hi all, I have a measure that contains a min(col) I have a matrix that has 1 parent and 1 child group. On the child level the min shows the correct values but on the parent level the min returns the min of the child level as a value. Is there anyway to sum this to top level?

[OwenAuger · Accepted solution]

@Mark_Timson 

If you want to sum the minimum values by Child and return this sum at the Parent level, a measure something like this should do the trick:

Sum of Min by Child =
SUMX ( 
    VALUES ( YourTable[Child] ),
    CALCULATE ( MIN ( YourTable[Col] ) )
)

For an individual Child, you will still just see the min value, but at the Parent level you should see the sum across Children.

Regards,

Owen

[Mark_Timson]

Thank you very much ! This worked a treat. I need to get my head around using sum x and values and how this works specifically I think.