Display Competitors

Hi PiyushBQ 

According to your requirement, I suggest you add a measure to determine whether your selected category belongs to Fruit or Vegetable, and then use this measure to filter the table visual:

measure =

VAR CA = VALUES(slicer[Category])

VAR SKU = CALCULATETABLE( VALUES('Table'[SKU]), FILTER(ALL('Table'),'Table'[Category] in CA))

RETURN

IF(MAX('Table'[SKU]) in SKU,1,0)

Please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EVWD8lv5c09HvhlF_uT4PSIB5_M9K6m9MjVMFapTyTh5uQ?e=gr9swR

Best Regards,

Dedmon Dai