Why doesn't the Measure NumProductsSolds work in the Power Bi?

[jch]

I'm tearing my hair out here. Does anyone have suggestions?

Incorrect sum in Power Bi

This is how it sums in Excel

Pbi, December pivot table and transactions are in this drive

https://drive.google.com/drive/folders/1KnlQOQMVjPtGC-SiYBwCy15H4tR6JRwt?usp=sharing

[amitchandak · Accepted solution]

@jch , Your product is generated using =RANDBETWEEN(1,6)

That is why I was thinking how come I am getting a different sum for the product each time, I load it to power bi

edit

@MFelix , I have noticed that you have already given an update. But I am keeping this because I found this issue with excel, which creating the confusion

[jch]

@amitchandak thank you for keeping me sane. Wishing you a safe and happy New Years

[MFelix]

Hi @jch ,

Altough your data is similar is not the same in the excel and in PBI has you can see below in Excel you have 25 records for product 1 in december however in the PBI the count is 40:

Are you sure that your model copied to PBI is correct.