topic Re: DAX in DAX Commands and Tips

DAX

Cyriackpazhe — Wed, 12 Mar 2025 08:52:37 GMT

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

Re: DAX

Cyriackpazhe — Wed, 12 Mar 2025 09:32:07 GMT

It shows the one with calculate yields the correct result

Re: DAX

johnt75 — Wed, 12 Mar 2025 10:30:56 GMT

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.

Re: DAX

v-echaithra — Thu, 29 May 2025 14:23:53 GMT

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.

Re: DAX

v-echaithra — Mon, 02 Jun 2025 03:24:07 GMT

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.

Re: DAX

v-echaithra — Thu, 05 Jun 2025 05:41:47 GMT

Hi Cyriackpazhe ,

Regards,
Chaithra.