calculation help

Hi,

I suggest having a disconnected table like below, and put the measure (below) into the Visual Filters Pane.

Please check the below picture and the attached pbix file.

Filter pane measure: =
IF (
    COUNTROWS (
        FILTER ( Number, NOT ( Number[Number] IN DISTINCT ( Data[Number] ) ) )
    ) = 0,
    0,
    1
)

Hi Gopinath_iyer ,

Check this formula:

Measure = IF(SELECTEDVALUE('Table (2)'[Number]) in DISTINCT('Table'[Number]),1,0)

Best Regards,

Jay