Filter a column based on another column dynamically from excel

Hi Evanooruvan ,

1-You need to define a scheduled refresh to update the data comes from Excel source. Or if you use the desktop version (without publishing), you can do the refresh manually.

2-Assuming you have threshold per Object in a table named 'ThresholdTable' ,You just need a Measure. Assume the main table name is 'MainTable'. Then the measure below is what you need:

CALCULATE (
    SUM ( 'MainTable'[Quality] ),
    FILTER (
        CROSSJOIN ( 'MainTable', 'ThreasholdTable' ),
        'MainTable'[Object] = 'ThreasholdTable'[Object]
            && 'MainTable'[Quality] > 'ThreasholdTable'[ThresholdValue]
    )
)

If this answer solves your problem, give it a thumbs up and mark it as an accepted solution so the others would find what they need easier.

Regards,
Loran

Evanooruvan 

And if you only want it as a filter:

SUMX (
    FILTER (
        CROSSJOIN ( 'MainTable', 'ThreasholdTable' ),
        'MainTable'[Object] = 'ThreasholdTable'[Object]
            && 'MainTable'[Quality] > 'ThreasholdTable'[ThresholdValue]
    ),
    1
)

Then put this measure on your table visual and set it as "IS 1" on the filter pane. Then it filters your Table Visual.