latest value text

Hi Anonymous ,

You can create two measures as below, then create a bar chart with Product Level field on Axis fields and new measure “CountofPlevel" on Values field:

NProduct Level =
VAR _maxdate =
    CALCULATE (
        MAX ( 'Table'[Date] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Product ID] = MAX ( 'Table'[Product ID] ) )
    )
RETURN
    CALCULATE (
        MAX ( 'Table'[Product Level] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Product ID] = MAX ( 'Table'[Product ID] )
                && 'Table'[Date] = _maxdate
        )
    )

CountofPlevel =
VAR _tab =
    SUMMARIZE ( 'Table', 'Table'[Product ID], "Npl", [NProduct Level] )
RETURN
    COUNTROWS ( FILTER ( _tab, [Npl] = MAX ( 'Table'[Product Level] ) ) )

Best Regards

Rena