Return rows with duplicates based on column status

Hi ljx0648 ,

I have created a simple sample, please refer to my pbix file to see if it helps you.

Create a measure.

Measure =
VAR _1 =
    MAXX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Customer ] = SELECTEDVALUE ( 'Table'[Customer ] )
        ),
        'Table'[Asset]
    )
RETURN
    IF ( MAX ( 'Table'[Asset] ) = _1, 1, BLANK () )

Or a column.

Column =
VAR _1 =
    MAXX (
        FILTER ( ALL ( 'Table' ), 'Table'[Customer ] = EARLIER ( 'Table'[Customer ] ) ),
        'Table'[Asset]
    )
RETURN
    IF ( ( 'Table'[Asset] ) = _1, 1, BLANK () )

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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