Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

List.Average and Select rows

Hello, could someone help me with this problem? I am trying to add this formula =List.Average(Table.SelectRows(#"added custom6", each [roles] = _[roles])[wage])   I have this table ROLES WAG...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
1 year ago

Anonymous , You should create a meausre in DAX

 

Measure =

Average(Table[WAGE])

Anonymous's avatar
Anonymous
Not applicable
1 year ago

yeah but it would do the same think that i do not want, right? - making average of all wages, not specified (or i am wrong, i am still beginner)

 

and I would lke to create it in power query if its possible

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    1 year ago

    Anonymous , A calculated column DAX or Power Query will sum up entire column unless you put filter, while measure will group for the context,

     

    refer

    Complete Power BI in one Video 11 hours:
    https://www.youtube.com/watch?v=cN8AO3_vmlY