Hi,Please find 'MDX query to filter data based on role' :https://social.msdn.microsoft.com/Forums/sqlserver/en-US/0b88574a-512c-4388-aa4e-bd0f8ed1e12c/mdx-query-to-filter-data-based-on-role?forum=sqlanalysisservicesDepending upon this you can try for your Base table.