I have two data sheets that I would like to blend togather. First I have the data with sales and Products.

Second I have a file that tells if the Product is a focus Product or not. So in my example all Products called Toy, Cream or Ice should be filtered as new in my calculation below.

IF ATTR([Product]) = ATTR([New products (New Products)].[Products]) THEN 'New' END

It works fine if I use the Product field in my dashboard

But when I try to show Group only New seems to get lost and move to the null side. I cant figure out how I can be able to use this second sheet with focus Products?

Hope you can help me out. I have attached an example too.

data source 1

data source 2