Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
BaileyL
Frequent Visitor

Count date values from list of items with purchase date

Beginner here, 

 

I have a table of items, with: ID's, Names, Purchase quantity and Purchase Dates. Many items were bought on the same day. 

 

I want to be able to filter the items so the return graph show:

X = Dates between first and last Purchase date (Returns all dates, regardless if 0 items were bought)

Y= The count of items purchases on each date (not quantity - the amount of times a date occurs)

 

What is the approach I would do to achieve this? I have a date table linked with Purchase dates but no matter what it returns BLANK. 

 

It's trivial but nothing I do seems to work. 

Thanks. 

 

Thanks. 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@HotChilli  Thanks for your contribution on this tread.

Hi @BaileyL ,

You can create a measure as below and apply the measure onto your visual to get it:

 

Measure = DISTINCTCOUNT('Table'[ID's]) +0 

 

vyiruanmsft_0-1714115861420.png

Best Regards

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

@HotChilli  Thanks for your contribution on this tread.

Hi @BaileyL ,

You can create a measure as below and apply the measure onto your visual to get it:

 

Measure = DISTINCTCOUNT('Table'[ID's]) +0 

 

vyiruanmsft_0-1714115861420.png

Best Regards

HotChilli
Super User
Super User

Sample data would help.

What visual are you using?

What have you got in the field well for each axis? (if it's a chart).

If using a date table, have you double-checked that the relationship is working?

What is the expected result?

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors