Count Rows of Values not correct

[moezsajwani]

Hi,

I am trying to use the following measure for educational purpose.

ValuePromotionKey = COUNTROWS(VALUES(Sales[PromotionKey]))

There are only 3 promotion key in promotion table and only 3 of them are used in Sales Table. There should be no auto blank row created in this case. Relation of promotion table to Sales is 1 to many (unidirection).

The answer the above measure returns is 4 instead of 3. I believe VALUES is intended to remove duplicate values and only return unique which should be 3 in this case.

Any body can help me clarify the concept here please?

Regards,

M

[v-piga-msft]

Hi @moezsajwani,

By my test, I cannot reproduce your scenario with Values.

If it is convenient, could you share some data sample and your desired output so that we can help further investigate on it?

Best Regards,

Cherry