Forum Discussion

taurius2022's avatar
taurius2022
Frequent Visitor
4 years ago
Solved

Summarize average for unique vaalue for every month

Hello community,   I have encountered a following problem. Neitheer reading an extensive Power BI forum, nor YouTubing helps.   I have the following data set:     First, I would like to ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi taurius2022 ,

     

    average count of Unique-ID for the month:

    =

    var _s = SUMMARIZE('Table',[Month],[Unique-ID],"sum of events",SUM('Table'[SUM]))
    return
    AVERAGEX(_s,[sum of events])
     
     
    average sum for a month based on the number of unique-id:
    = AVERAGE('Table'[SUM])

     

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi taurius2022 ,

 

average count of Unique-ID for the month:

=

var _s = SUMMARIZE('Table',[Month],[Unique-ID],"sum of events",SUM('Table'[SUM]))
return
AVERAGEX(_s,[sum of events])
 
 
average sum for a month based on the number of unique-id:
= AVERAGE('Table'[SUM])

 

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.