Forum Discussion

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

7 Replies

MFelix
Super User
8 years ago
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
  Frequent Visitor
  8 years ago
  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
    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

Related content