Forum Discussion

oll's avatar
oll
New Member
9 years ago
Solved

AVERAGE IF function DAX

Hey,   Wonder if there is a way to make a calculated measure to calculate the average of all numbers that belongs to a certain category.   For example, if there is a DAX expression to calculate t...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    oll

     

    Hi, a way to obtain this is:

     

    AverageNumberofComputers=Calculate(average(Table[ColumnNumbers]),Filter(Table, Table[ColumnName]="Computers"))

     

    Let me know if you need more help

  • Sean's avatar
    Sean
    9 years ago

    If you want to calculate the average only for 1 category at a time go with the above method

    However if you have MANY more categories you can create a simple average measure and use it in a Matrix

    Place category in the Rows and that Measure will be sliced per Category

    Average Measure = AVERAGE ( 'Table'[Value] )

    Even easier you can just drag the value column again to the Values area - right click and change the aggregation - as shown below...

    Hope this helps! :smileyhappy:

     

     

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

oll

 

Hi, a way to obtain this is:

 

AverageNumberofComputers=Calculate(average(Table[ColumnNumbers]),Filter(Table, Table[ColumnName]="Computers"))

 

Let me know if you need more help

stefanot's avatar
stefanot
Frequent Visitor
3 years ago

can you please clarify how you'd use the same formula

 

AverageNumberofComputers=Calculate(average(Table[ColumnNumbers]),Filter(Table, Table[ColumnName]="Computers"))

 

but instead of filtering by a defined value ("Computers") to filter it by the each single line value of the "[ColumnName]" column?