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 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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