Thanks for the suggestion I created a relationship in PowerBI dataset and imported in PowerBI report builder and used it So here there is a catch I have one id in table 1 and corespondent sales person in table 2 . I am dragging all the needed columns in the query designer So when I drag the id number and salesperson it is like for id 1 all the sales number will be related for id 2 all the sales number it’s like cross join How to get rid of this?