Why the DISTINCTCOUNT gives different number when Variable and non Variable setting

[kelvin-lkhca]

Hi All Experts,

Please find below the dataset, measures and the outcome of the distinctcount in the matrix table. I have posted the source file with the link at below. My question is why the 2 measures are giving different outcome in the matrix table given their Dax measure are the same, just that 1st one with Variable created and 2nd one is without the variable. shouldn't the logic or flow be the same for both measure?

Thank you for your kind coaching in advance.

Dataset

Measure 1

Measure 2

Matrix Tables

https://drive.google.com/drive/folders/1vkOBb92F3hLBzh-dBzKNES6TFaWp4oHZ?usp=sharing

[amitchandak · Accepted solution]

@kelvin-lkhca , Please refer to this article from Radacad explaining how variable works.

https://radacad.com/caution-when-using-variables-in-dax-and-power-bi

[kelvin-lkhca]

That is a nice post and clear explanation. Thanks a lot!