Forum Discussion

bhartsell's avatar
bhartsell
Frequent Visitor
9 years ago
Solved

Count per day in calculated table

I have two tables, one of which has logs that occur multiple times throughout the day, and the other is a Date table. They are connected through a relationship between the date columns.    I'm tryi...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi bhartsell,

     

    Now that you have connected the two tables through a one to many relationship based on “date”. Please try this formula to create a calculated column:


    CountRows = COUNTROWS(RELATEDTABLE(Table_Log))

     

    If you have any question, please feel free to ask.

     

    Best regards,
    Yuliana Gu

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

Hi There,

 

Assuming that you have one to many relationship between your date table and log table,

 

Use following DAX Formula for  count in Calculated column

 

Count:=CALCULATE(COUNTROWS(log table))

 

 

Thanks & Regards,

Bhavesh

bhartsell's avatar
bhartsell
Frequent Visitor
9 years ago

Thanks for the reply!

 

I've tried this, but when I do the result is that it counts the rows for all time, not just for whatever day the row is. 

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    9 years ago

    Please post your data model and sample data for further check.

     

    Thanks & Regards,

    Bhavesh