Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

How to get average of countrows in a table as total

Hi guys,

 

After being a reader of this community for weeks, I would need some help for this unanswered question.

 

It's quite simple, but I couldn't find the solution. I would like to get the average as the total of the table of a measure which counts the number of rows.

Here is my data sample

aso_be_0-1659536763798.png


I would like the average next to the red arrow.

My measure are

nb_days_active =
    AVERAGEX(
        'blabla,
        CALCULATE(Countrows('blabla'))
    )
   
nb_days_stock =
              CALCULATE(
                        AVERAGEX('blabla',COUNTROWS('blabla')),
                    'blabla'[quantity_stock_internal]>0
                    )

Thanks in advance 🙂 


1 ACCEPTED SOLUTION
Anonymous
Not applicable

I found the solution. I needed to add the countrows within my summarize 

 

     AVERAGEX(
         SUMMARIZE('blabla','blabla'[id],"active_days",COUNTROWS('blabla')),
         [active_days]
     )

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

I found the solution. I needed to add the countrows within my summarize 

 

     AVERAGEX(
         SUMMARIZE('blabla','blabla'[id],"active_days",COUNTROWS('blabla')),
         [active_days]
     )

I am so glad to hear that your problem has been solved . Please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Anonymous , This average need a level/column/group by. The one used in visual '

 

nb_days_active =
    AVERAGEX(
        values('blabla'[Column]) ,
        CALCULATE(Countrows('blabla'))
    )
 
or
 
nb_days_active =
    AVERAGEX(
        summarize('blabla','blabla'[Column],'blabla'[Column2]) ,
        CALCULATE(Countrows('blabla'))
    )
Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Thanks @amitchandak for your fast reply. I tried both, but still, the total is a sum. 😞

What am I doing wrong?

nb_days_active =
//if a product is active, there is a row in the table every day, if the product has got stock

    nb_days_active =
     AVERAGEX(
         SUMMARIZE('blabla','blabla'[id],'blabla'[snapshot_date]),
         Countrows('blabla')
       )

or

nb_days_active =
     AVERAGEX(
         SUMMARIZE('blabla','blabla'[id]),
         Countrows('blabla')
       )
 
The first row of my table is the ID (of the product), it still doesn't average the total.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.