drived value based on a dataset

show =
VAR a =
    ADDCOLUMNS (
        VALUES ( 'Table'[Record Number] ),
        "nulls",
            VAR r = [Record Number]
            RETURN
                CALCULATE (
                    COUNTROWS ( ALLSELECTED ( 'Table' ) ),
                    'Table'[Record Number] = r,
                    ISBLANK ( 'Table'[Received Date] )
                )
    )
RETURN
    IF ( SUMX ( a, [nulls] ) > 0, 0, 1 )

Hi Anonymous ,

Thanks lbendlin  for the quick reply and solution. I have a other thought to add:

(1) We can create a new table.

Table 2 = 
var _table=SELECTCOLUMNS(FILTER('Table',[Quantity]>[Received Quantity]),"record",[Record Number])
RETURN FILTER('Table',not [Record Number] in _table)

(2) Or we can create a [Flag] measure and place [Flag=1] on the visual filter.

Flag = 
var _table=SELECTCOLUMNS(FILTER(ALL('Table'),[Quantity]>[Received Quantity]),"record",[Record Number])
RETURN IF(MAX('Table'[Record Number]) in _table,0,1)

(3)  Then the result is as follows.

Best Regards,

Neeko Tang

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