help DAX dataset on ssas tabular for reporting services
I need to write a DAX query for a reporting services report the data source is a ssas tabular cube the datamodel is kimball dim model requirements The dataset needs to include columns from one fact table and two related dimension tables only a few columns from each table shall be included the dataset shall be filtered from SSRS parameters (both fact and dimension table) baically what I need is help writing a query that joins the three tables (inner join) as efficient as possible I am elaborating with selectedcolumns, different types of joins (related, naturalimnerjoins, lookup) and filter function I would approciate some input here