Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Basic stats for a given field

If accessing a database directly, as opposed to via powerbI, I could find info about a given field by running a bit of SQL - for instance:    SELECT AVG(field_name) AS averageVal FROM tableName   ...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  Anonymous ,

     

    Modify your measure as below:

    Measure = 
AVERAGEX(ALL('Table'),VALUE('Table'[values]))

    And you will see:

     

    For the related .pbix file,pls see attached.

     

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Create a measure and you can use it

measure = AVG(Table[field_name])

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks! 

    I had tried that, but received the error that average could not operate on string values. 

    All of the values in the column are numeric - but it may be that they are stored in the database as numeric striungs rathert than as integers. Not sure if there is a way I can cast them to ints....

     

    I tried adding a measure that called VALUE() on each numeric field - but there seems to be some kind of syntax issue 

     
    It seems I can't add a calculated colum to the data, since it is live streamed from a remote database 
     
    Reregarding the conditional cloauses - so the equiavalent of: 
    Measure = AVERAGE(events[param1]) where date range is X for instance
     
    It looks like I have to enable the time field, then  add the filter, then disable the field again? That seems clunky, though it does work, so not sure if there is a neater way!