Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

average

Hello,
I have created a table and assigned it to variable myCount
The table I get is like:

Field1 Field2
----------------------
value1 3
value7 1
value4 1
value5 9
...

Question

How do I get the avg of Field2 in dax?

Thank you

  • AlB's avatar
    AlB
    7 years ago

    Hi Anonymous 

    AVERAGEX(myCount, [Field2] )

     

    Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.

    Cheers  Datanaut

     

1 Reply

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Hi Anonymous 

    AVERAGEX(myCount, [Field2] )

     

    Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.

    Cheers  Datanaut