Forum Discussion
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...
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
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.