Forum Discussion

nick9one1's avatar
nick9one1
Helper III
2 years ago
Solved

average distinct users per month

I have a table that contains information on users accessing a webpage.  I'm using the following measure to get unique users per day (this is used for the line chart and is correct).       cou...
Need Help
  • swikritee_p's avatar
    swikritee_p
    2 years ago

    nick9one1 ,  Create a Date table and join the Date (Without time) with Date of date table and create a measure given below 

     

    Avg of Month =
    calculate(
    Averagex(Values('Date'[Year Month]) , calculate(
    COUNTROWS (
    SUMMARIZE ( 'cr20b_commscampusauditlogs3', 'cr20b_commscampusauditlogs3'[UserId], 'Date'[Date])
    ))), removefilters('date'))

swikritee_p's avatar
swikritee_p
Resolver II
2 years ago

nick9one1 ,  Create a Date table and join the Date (Without time) with Date of date table and create a measure given below 

 

Avg of Month =
calculate(
Averagex(Values('Date'[Year Month]) , calculate(
COUNTROWS (
SUMMARIZE ( 'cr20b_commscampusauditlogs3', 'cr20b_commscampusauditlogs3'[UserId], 'Date'[Date])
))), removefilters('date'))