Forum Discussion

Frequent Visitor

4 years ago

Solved

How to sum max values in table?

Hi! I've the following issue: I have table with such data as: training name, trainer name, traing staring date, length (hours) --> where length is shown as max value (I don't want to sum up per row...

Need Help

SpartaBI
4 years ago
kasiak put this instead of the lengh column you used in the visual:

Length Measure = SUMX( SUMMARIZE( 'Table'[Training Title], 'Table'[Training Name], 'Table'[Training Start Date] ), CALCULATE(MAX('Table'[Length (hours)] )

'Table' is the name of your table and 'Table'[Length (hours)] is the name of the column with hours.

Showcase Report – Contoso By SpartaBI