SSRS Mobile – the only 6 DAX queries you need
All the 30 types of SSRS Mobile reports (as of July 2016) can be designed with only 6 base queries. These six queries can be written in either DAX, or MDX, or SQL. This is the DAX version. And, with a bit of imagination some of these six queries can be combined so that you end up with even fewer than six for all report types – I have used six here as the SSRS Mobile sample reports use a total of six datasets in the SQL Server Mobile Report Publisher. Even better news! 23 of the 30 report types can be designed using just 1 query (the SimulatedTable query). The six DAX queries are at the end of this post, so please scroll to see the syntax. They all use the Adventure Works SSAS tabular model (available from codeplex).