how to avoid counting up on the date with the same quantity ?

[Chanleakna123]

HI All , 

How to avoid counting up on the date with the same quantity ? I couldn't make visualization while the data was counted up on the same date as well as the date also count up. And i have many many of products which is the same date and i also have the calculated date in which this calculated date was counted upo. How to avoid this ? 

Thanks 

[v-jiascu-msft]

Hi @Chanleakna123,

Do these columns have proper data type? Usually, dates couldn't be counted. Could you please provide a sample in TEXT mode? The PBIX file would be great.

Best Regards!

Dale

[BeemsC]

Use DISTINCTCOUNT(