I am not able to get distinct count based on date

[Anonymous]

I am not able to get distinct count based on date

Date            Count(ID)

12/7/2011 -->1

12/7/2011 -->2

12/7/2011 -->3

12/7/2011 -->4

12/7/2011 -->5

my aim to show  12/7/2011 -->15

how to achieve

[edhans]

Just create a measure:

Total of CountID = SUM(TableName[Count ID])

When you put your date in a table visual or matrix visual (or any visual for that matter) the [Total of CountID] will automatically total it based on the date.

[Anonymous · Accepted solution]

i tried it,but i guess there is problem in data type of date column so i am unable to achieve it,i tried extracting the date format from date column format(columnname,"DD/MM/YYYY").By this i am geting separate column and i am able to achieve it

[parry2k]

@Anonymous your question is not at all clear, you should read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Hi Ravi,

when click dropdown on measure field in field properties,  select sum or don't summarize using two option you can get you solution.

[parry2k]

@Anonymous can you provide the logic what you mean by distinct count and how you get to number 15? What is 1,2,3,4,5...