Tools for Querying TabularDAX Query SyntaxUsing CALCULATETABLE and FILTERUsing ADDCOLUMNSUsing SUMMARIZEUsing CROSSJOIN, GENERATE, and GENERATEALLUsing ROWUsing CONTAINSUsing LOOKUPVALUEDefining Measures Inside a QueryTest Your Measures with a QueryParameters in DAX QueryUsing DAX Query in SQL Server Reporting ServicesQuerying by Using MDXUsing DAX Local Measures in MDX QueriesDrillthrough in MDX QueriesChoosing Between DAX and MDXSummary