Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Experiencing Count Issues with my data

Hello! I am experiencing some issues getting correct counts with my data. I have attempted to create new measures using all of the different count dax featured in this video: https://www.youtube.com/watch?v=KP_wUQ7bHNM

 

I am specifically trying to count my Order ID's which is alpha numeric with this column settings:

 

I want to be able to get a count of the number of orders I have by Check Out Date. So I created a table visual to see my Order ID by Check Out Date:

 

I then created my new measure with this dax: 

 

I created a new line chart visual with Check Out Date as my X-Axis and # Total orders as my Y-Axis. If I find October 16, 2022, the count is only 3

 

Trying all count methods from this video: https://www.youtube.com/watch?v=KP_wUQ7bHNM - I still am experiencing the same issue. 

 

Any assistance is greatly appreciated!

  • is 'check out date' a date or datetime?

    Maybe you can show us the same rows in Power Query?

    -

2 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion

    is 'check out date' a date or datetime?

    Maybe you can show us the same rows in Power Query?

    -

  • Anonymous's avatar
    Anonymous
    Not applicable

    I think that fixed my issue. I've updated in Power Query to be just date instead of date/time and updated in the report and all seems to be working now. Thank you!