Count per day

[RTW93]

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.2017.

Now i tryed to get a new colum in "calendar" [ID count]. This Colum should show me how many id's from "login" logged in per day.

can someone help me?

Thank you

RTW-93

[MFelix]

Hi @RTW93,

You don't need to create a new column if you add the date column (from calendar table) and the ID and select summarize count it will give you the expected result be aware that you need to have both tables related.

Regards,

MFelix

[RTW93]

Hey MFelix,

thanks for your answer,  but i need the Colum saved in the table (using table/new Colum). Based on it i need to calculate some other things...

[MFelix · Accepted solution]

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]

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]

Hi @anandsonar1 ,

Can you please share a sample data and expected result.

[RTW93]

Thanks again,

if i use your Solutions i get on every day 3603 (the count of all rows).

[MFelix]

You need to relate both tables to use this formulas.