Forum Discussion

MooseButt's avatar
MooseButt
New Member
8 years ago
Solved

How to create a AVERAGE for a Text Column

I have a table that has a text column that I can use the COUNT DAX function, but now I want to take an AVERAGE of that count.       The 'Request:Request Name' column is what I have as my COUNT ...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi MooseButt,

     

    Do you mean you want the Total returns average values? For example, the first row of the matrix, (2479+2562)/2=2520.5. 

     

    If it is, you can create a measure below: 

     

    Measure = var temp=SUMMARIZE('Table1','Table1'[Edited By],'Table1'[Edit Date].[Month],"CountVal",COUNTROWS('Table1'))
    return
    AVERAGEX(temp,[CountVal])

     

     

    Best Regards,
    Qiuyun Yu 

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi MooseButt,

 

Do you mean you want the Total returns average values? For example, the first row of the matrix, (2479+2562)/2=2520.5. 

 

If it is, you can create a measure below: 

 

Measure = var temp=SUMMARIZE('Table1','Table1'[Edited By],'Table1'[Edit Date].[Month],"CountVal",COUNTROWS('Table1'))
return
AVERAGEX(temp,[CountVal])

 

 

Best Regards,
Qiuyun Yu 

MooseButt's avatar
MooseButt
New Member
8 years ago

That did it Qiuyun Yu!  Thank you for your support!