Forum Discussion
Counting rows/entries pr date not working.. why?
This is my data set (about 100000rows) I want to count how many files are created each day.
I havde created a Calender (Kalender = CALENDAR(MIN('Query'[CreatedDate]),MAX('Query'[CreatedDate])))
and set up the following relation. Date -> CreatedDate (1:*)
My measure for counting is Count = DISTINCTCOUNT('Query'[CourseElementId])
The result is not exactly impressive… 🙂 im obviously not doing it right. But what am I not getting?
Hi moei,
Perhaps you can try to use the following measure formula if it works on your side:
Count = CALCULATE ( COUNTROWS ( VALUES ( 'Query'[CourseElementId] ) ), VALUES ( Calendar[Date] ) )If the above not help, can you please share some dummy data to test?
How to Get Your Question Answered Quickly
Regards,Xiaoxin Sheng
5 Replies
- lbendlin
Super User
"My measure " - you either need to use a calcuated column, or change your measure formula.
- Ashish_Mathur
Hi,
I cannot spot the mistake in what ou have done. Share the link from where i can download your PBI file.
Hi moei,
Perhaps you can try to use the following measure formula if it works on your side:
Count = CALCULATE ( COUNTROWS ( VALUES ( 'Query'[CourseElementId] ) ), VALUES ( Calendar[Date] ) )If the above not help, can you please share some dummy data to test?
How to Get Your Question Answered Quickly
Regards,Xiaoxin Sheng
