Forum Discussion

RealTrentG's avatar
RealTrentG
Frequent Visitor
11 months ago
Solved

Average all rows on Power BI matrix

I want to add a meaure that averages the 'STORE COUNT' column for all rows in attached Power BI matrix.  The STORE COUNT column is a Count summarization in the Values section of the matrix.  I would ...
Need Help
  • v-venuppu's avatar
    v-venuppu
    11 months ago

    Hi RealTrentG ,

    Can you please share the sample data as requested earlier, so that it will be helpful for us to solve the issue.

    Thank you.

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
11 months ago

RealTrentG To create a measure in Power BI that averages the 'STORE COUNT' column for all rows in your matrix, you can use the following DAX

DAX
Average Store Count = AVERAGE('YourTableName'[STORE COUNT])

 

If you want it not to be impacted by any filter you can use it with ALL function

  • RealTrentG's avatar
    RealTrentG
    Frequent Visitor
    11 months ago

    Thanks for the prompt reply!  [STORE COUNT] is not a field in my table though.  The matrix is using Count of STORE.  So I guess the question is, how do I write DAX to take an average of Count of STORE for each row, i.e. for each RTLR_NAME