Measure - Filtered table

Hi , RichardTam 

For your dax , the LOOKUPVALUE() is the function used in the "Calculated column" not a measure .

If you want to make diffrent people to see diffrent data , you can use RLS in Power BI.

For more information, you can refer to :
Dynamic Row Level Security (Dynamic RLS) - Microsoft Power BI Community

Dynamic Row Level Security with Power BI Made Simple - RADACAD

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

Best Regards,

Aniya Zhang

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