Forum Discussion

RTW93's avatar
RTW93
Frequent Visitor
8 years ago
Solved

Count per day

Hey guys,   i try to solve my problem since 2 days... I have a table "login" with 2 Colums: [id] and [date] I Created a Extra Table "calendar" with all dates from the 01.01.2017 to the 30.07.201...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi RTW93,

     

    as a best practice you should use a measure and then apply it based on context because columns only add to your model, and if one expression can change into a measure do it instead of a column, but the syntax for the new colum in calendar table sould be one of this two:

     

    Count per day = CALCULATE(COUNT(Login[ID]), RELATEDTABLE(Login))
Count per day = COUNTROWS(RELATEDTABLE(Login))

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
8 years ago

Hi RTW93,

 

as a best practice you should use a measure and then apply it based on context because columns only add to your model, and if one expression can change into a measure do it instead of a column, but the syntax for the new colum in calendar table sould be one of this two:

 

Count per day = CALCULATE(COUNT(Login[ID]), RELATEDTABLE(Login))
Count per day = COUNTROWS(RELATEDTABLE(Login))

Regards,

MFelix

anandsonar1's avatar
anandsonar1
Frequent Visitor
4 years ago

Hi MFelix, I have bit similar problem but in my case I have one more column of True/False and I want to take only true rows..How could I do this. Could you please address.

  • MFelix's avatar
    MFelix
    Super User
    4 years ago

    Hi anandsonar1 ,

     

    Can you please share a sample data and expected result.