Forum Discussion

NISH72's avatar
NISH72
Helper 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 thanks
Need Help
Show and Tell

1 Reply

  • TomMartens's avatar
    TomMartens
    Super 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