AVERAGE IF function DAX

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

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: