Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Robert-RK
Regular Visitor

DAX syntax sugar examples

Hi,

 

I just came accross article on  syntax sugar in DAX - https://exceleratorbi.com.au/simple-filters-and-syntax-sugar-in-dax/

 

1.

Total Sales Syntax Sugar = SUM(Sales[ExtendedAmount])

Total Sales Full Syntax = SUMX(Sales, Sales[ExtendedAmount])

2. 

Total Sales Prior Year Syntax Sugar =
CALCULATE(
[Total Sales],
SAMEPERIODLASTYEAR('Calendar'[Date])
 
Total Sales Prior Year Full Syntax =
CALCULATE(
[Total Sales],
DATEADD('Calendar'[Date], -1, YEAR))
 

3. 

Total Sales of Bikes Simple =
CALCULATE(
[Total Sales],
Product[Category] = "Bikes")
 
Total Sales of Bikes Full Version =
CALCULATE(
[Total Sales],
FILTER(
ALL(Product[Category]),
Product[Category] = "Bikes"))

 

Does anyone know other exampes of syntax sugar in DAX?

 

Robert

1 REPLY 1
harshnathani
Community Champion
Community Champion

Hi @Robert-RK ,

 

https://www.sqlbi.com/articles/analyzing-distinctcount-performance-in-dax/

 This is Syntax Sugar for CountRows and Distinct.

 

https://www.sqlbi.com/?s=syntax+sugar

 

Once you open any article in Chrome, just press Ctrl+F and Seach for Sugar in each articles in the link provided above and you will get many more examples.

 

Regards,

Harsh Nathani

 

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.