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
Cyriackpazhe
Helper III
Helper III

DAX

Screenshot (52).png
Screenshot (53).png

Why do i get different result on adding and removing the calculate in the Variable First. Which is the correct one when i want to compute the sales amount of first day of sales of the product

5 REPLIES 5
v-echaithra
Community Support
Community Support

Hi @Cyriackpazhe ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,
Chaithra.



v-echaithra
Community Support
Community Support

Hi @Cyriackpazhe ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks and Regards,
Chaithra E.

v-echaithra
Community Support
Community Support

Hi @Cyriackpazhe ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,
Chaithra.

johnt75
Super User
Super User

CALCULATE forces context transition. SUMX is an iterator which introduces a row context over the Products table, but the row context will not affect the filter context, so when you are getting the min sales date without CALCULATE you are getting the min sales date of all products, so the first ever sale.

When CALCULATE performs context transition the row context from the Products table is turned into a filter context, which means that the sales table is filtered to only sales for that individual product. At that point the min sales date is the first sale date for that specific product.

Cyriackpazhe
Helper III
Helper III

Screenshot (54).pngIt shows the one with calculate yields the correct result

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.