Forum Discussion

NISH72's avatar
NISH72
Icon for Helper IV rankHelper IV
7 years ago

Count function displaying same values for every row

Hi I want to count number of sales by date but the count measure is showing same value for every date. For eg 1 Jan -253 2 Jan -253 3 Jan -253 and so on I have created count (sales_id) measure...
Need Help
Show and Tell
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
7 years ago

Hey,

 

I guess the date column is from a separate table that is not related to the table with column sales_id.

 

If you relate both columns the measure will return what you expect.

 

Regards,

Tom