There is two rows instead of one.

Gaetan Mourmant 0

https://learn.microsoft.com/en-us/training/modules/dax-power-bi-time-intelligence/3-calculations

151 = 75 +76 for the products keys 359 and 358.

So the sentence

"Notice that the measure formula uses the SUM function. An aggregate function must be used (measures don't allow direct references to columns), but given that only one row exists for each product for each date, the SUM function will only operate over a single row."

is not valid

Rakesh Gurram 2,760 Reputation points Microsoft Vendor

2024-03-27T16:41:41.7933333+00:00

Hi Gaetan Mourmant,

Thank you for your question on Microsoft Q&A forum.

Thanks for raising this query. We are checking into it.
Syed Saleem Peera 390 Reputation points Microsoft Vendor

2024-03-28T03:36:18.86+00:00

Hi Gaetan Mourmant,

could you please provide more details about the error you're encountering. It would be helpful if you could send a snapshot of the error message or any relevant information.

Thank you
Gaetan Mourmant 0 Reputation points

2024-03-28T12:15:10.5733333+00:00

If you download the file adventure works, open the table inventory, filter for the datekey 20190731, and productkey 359 and 358 (the two prodcutkeys for Mountain-200 Black, 38), there are more than one row . The sum returns 151 (75+76) which is the result you give in your example.

Therefore, the following statement in the tutorial seems to be wrong, unless I missed something. There is more than one row for each product for each date.
Syed Saleem Peera 390 Reputation points Microsoft Vendor

2024-03-28T13:26:04.9933333+00:00

Hi Gaetan Mourmant,

As per the lab instructions, We aren't using "adventure work file". Kindly refer this link https://microsoftlearning.github.io/PL-300-Microsoft-Power-BI-Data-Analyst/Instructions/Labs/05-create-dax-calculations-in-power-bi-desktop-advanced.html to complete the exercise.

In general, In a day, people can buy multiple products).

Kindly refer the product keys 359 and 358. each one can refer to different products. that's why we have "unitsbalance" 75 and 76.

If you are still facing any issue, please let us know in the comments. We are glad to help you.

If the information is helpful, please Accept Answer so that it would be helpful to community members.

Thank you