Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

What would be the exact formula for this count function?

Hi,   I want to come up with a formula which aggregrates the number of creation times per person based on one day.        The column index is just 1. The second image shows that the...
Need Help
  • vanessafvg's avatar
    vanessafvg
    7 years ago
    Anonymous 
     
    create a calcualted column
    countfunction = CALCULATE(SUM(Table1[Index]), ALLEXCEPT(Table1, Table1[User Name], Table1[CreationTimeUTC.1]))
richbenmintz's avatar
richbenmintz
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi Anonymous 

I believe you are trying to create a summary table, try the following.

click in the model tab-> create table -> enter formula (please note table names will be different in your model)

 

Table = SUMMARIZE('Table1', Table1[User Name], Table1[CreationTimeUTC.1], "index count", sum(Table1[Index]))

Hope that helps