Counting rows/entries pr date not working.. why?

[moei]

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?

[Anonymous · Accepted solution]

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

[moei]

You solution worked! Thank you very much 😄 

[moei]

Thank you very much for your suggestion. I will try this asap.

[Ashish_Mathur]

Hi,

I cannot spot the mistake in what ou have done.  Share the link from where i can download your PBI file.

[lbendlin]

"My measure "  - you either need to use a calcuated column, or change your measure formula.