Writing DAX queries

Once the tabular model has been deployed to the server, the model can be made available to users for use with client tool applications. Users who will connect to the tabular database must be a member of a security role that has read access.

Typically, an end user will use a client tool application such as Excel, Power BI, Power BI Report Server, or another third-party tool, for example, to connect to a tabular database and browse the model. These types of tools will write the DAX query against the tabular database on behalf of the user as the user adds a column, measure, or filter to the report. But DAX queries can also be created using SSMS or other tools such as DAX Studio. A query defined and executed using SSMS will return the result set as a table.

Analysis Services object names are case-insensitive, so referring to the Internet Sales table as internet sales would give you the same table. See the following table for examples of how to refer to Analysis...