you need to use RELATED() DAX function for that and create a calculated columnAnd to see if its related just add an expression based on COUNTROWS function to check if count > 0 to get related ones------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs