Forum Discussion

moei's avatar
moei
Frequent Visitor
5 years ago
Solved

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'[CreatedDa...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
moei
Frequent Visitor
5 years ago

You solution worked! Thank you very much 😄