filter out upper level data

Hi  Gopinath_iyer ,

Create a slicer table as below:

Table 2 = VALUES('Table'[employee name ])

Then create 2 measures as below:

_employee name = SWITCH(SELECTEDVALUE('Table 2'[employee name ]),
"A",CALCULATE(MAX('Table'[employee name ]),'Table'[employee name ] in FILTERS('Table'[employee name ])),
"B",CALCULATE(MAX('Table'[employee name ]),'Table'[employee name ] in FILTERS('Table'[employee name ])&&'Table'[employee name ]<>"A"),
"C",CALCULATE(MAX('Table'[employee name ]),FILTER(ALL('Table'),'Table'[employee name ]="C")))

_age = 
var age=CALCULATETABLE(VALUES('Table'[age]),FILTER(ALL('Table'),'Table'[employee name ]=[_employee name]))
Return
IF(MAX('Table'[age]) in age,MAX('Table'[age]),BLANK())

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!