I have two facts table. First fact table is showing number of videos watched by patients and second fact table is showing number of patients admitted - patient census (not every patient admitted is watching video). Patient and Date dimensions are related to both fact tables but Video dimension is related to first fact table only. With date filter I have to report following measures per video name: - Total number watched (from first fact table) - Distinct patient number watched (from first fact table) - Patient census ( from second ) I also have to show utilization percentage (patient number / patient census). By using ether Ignore Unrelated Dimensions setting on measure group or VALIDMEASURE () function, Im getting all measures. Problem is that my patient census measure is relating to "all" (total) members only from other two measures and shows null(empty) to each individual video which also prevents me to calculate percentage. Im not sure if using Ignore Unrelated Dimensions or VALIDMEASURE () is right path to go in order to resolve a task. I have 8,600.000 videos watched and 2, 700,000 patients. Any suggestion how to answer on this question? Thanks! gb