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!

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey Anonymous ,

 

you can either do a measure as amitchandak already mentioned or you can just drop the column in a table and in the options of the value you can change the aggregation in this table:

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Ah - I think the problem is that though these values are numeric, th data source stores them as strings

Is there a way I can tell powerBI to treat these numeric strings as numbers? Unfortunately I don't think I can change the remote data source....

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    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!