Bar Chart Group By

Hi TimmK ,

You need to create a table with data generateseries from 0 to max value (60) for X aixs in column chart.

X aixs = 
VAR _SUMMARIZE =
    SUMMARIZE (
        ALL ( 'Piece' ),
        'Piece'[Piece Key],
        "SumDuration", SUM ( 'Piece'[Duration] )
    )
RETURN
    GENERATESERIES ( 0, MAXX ( _SUMMARIZE, [SumDuration] ), 1 )

Measure:

Count = 
VAR _SUMMARIZE =
    SUMMARIZE (
        ALL ( 'Piece' ),
        'Piece'[Piece Key],
        "SumDuration", SUM ( 'Piece'[Duration] )
    )
RETURN
    COUNTAX (
        FILTER ( _SUMMARIZE, [SumDuration] = MAX ( 'X aixs'[X aixs] ) ),
        [Piece Key]
    )

Result is as below.

Best Regards,
Rico Zhou

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