Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
computermike
Helper I
Helper I

I am learning Dax and just loaded DaxStudio, how do I develope measures

‎02-16-2018 08:45 AM

Hi I want to start learning how to write Measures in dax studio, but not sure how I would go about it.  For example I have a simple measure, SalesAmount:=SUM([Amount]).  How can I run this in Dax studio?  I tried just the =SUM([Amount]) and got nothing, added the = sign and got nothing.  Do I have to do in the contaext of an expression that returns a table?  What is the best way to develope complex Dax measures?

 

My model is in Tabular 2016.  I can connect to the model and see my Cube, tables and columns

 

Any help appreciated, Thanks,

 

Mike

 

Labels:
Message 1 of 4
7,457 Views
0
3 REPLIES 3
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

‎02-19-2018 12:05 AM

@computermike,

Please review the examples in the following blogs about developing measures in DaxStudio.

https://exceleratorbi.com.au/getting-started-dax-studio/
https://blog.learningtree.com/editing-dax-queries-dax-studio/

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 4 of 4
7,412 Views
Greg_Deckler
Super User
Super User

‎02-16-2018 09:10 AM

Are you connected to a PBI Model or Tabular Server?

 

When you pull up DAX Studio, it should ask you to connect to something.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Message 2 of 4
7,449 Views
0
computermike
Helper I
Helper I
In response to Greg_Deckler

‎02-16-2018 09:23 AM

Thanks...   added that info to original post.

Message 3 of 4
7,443 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All