Count of items per day

[EllaJ234]

Hi, 

I'm struggling to create a measure that counts the number of items per day in my issue log. However, I cannot get a count of the number of times a certain platform is used for each date in the Created Date column. I feel this is because there are duplicate Created Dates are in the table to account for more than one issue across the platforms. 

So for example: 

Created Date	Platform	Issue Type
01/01/2020	A	xyz
01/01/2020	A	xyz
02/01/2020	A	xyz
02/01/2020	B	xyz

So I would like a count that shows that on 01/01/2020 there were 2 instances of Platform A. But it seems a lot of count functions struggle when there are duplicate dates. Or just attempt to count all instances across the entire table. The main reason I would like a count for this is so I can create a line graph with the date as the x-axis and count per day on the y axis. 

Thank you in advance 😄 

[EllaJ234 · Accepted solution]

Hi everyone! 

Thank you for all of your answers! I tried them all but couldn't get exactly what it was I wanted. After some futher playing around I found that if I created a duplicate of data table, filtered by each platform  and removed all columns except for the date and the platform I was then able to apply a simple count equation. This gave me exactly what I needed which was how many times each platform appeared for each date. I've checked the accuracy against the raw data file and it all looks good! It might be a longer way of doing things but it works and doesn't look messy 🙂 

Using this I've now been able to create line graphs and tables with the figures I need!

Thanks again! 

[Nicharee2205]

Could you please post the example code and the duplicated table for me? I'm not sure how to do this. Thank you!

[Ashish_Mathur]

Hi,

Your question is not clear.  Drag Created Date and Platform to the matrix visual and write this measure

=distinctcount(Data[Issue type])

Hope this helps.

[Anonymous]

Hi @EllaJ234 ,

Please have a try.

Create a measure.

Measure = CALCULATE(COUNT('Table'[Platform]),FILTER(ALL('Table'),'Table'[Created Date]=SELECTEDVALUE('Table'[Created Date])&&'Table'[Platform]=SELECTEDVALUE('Table'[Platform])))

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@EllaJ234 , exepcted output is not clear.

Try measure like

countrows(summarize(table, [Created Date],[Platform Issue],[Type]))

or

countrows(summarize(table, [Created Date],[Platform Issue]))