topic How to use average DAX function for measure in DAX Commands and Tips

How to use average DAX function for measure

Anonymous — Fri, 08 Apr 2022 05:21:58 GMT

I have created new measure in the table . i have copied measure in the below

Total_Machine_park = CALCULATE(DISTINCTCOUNT('Manning calculation'[ID]),'Manning calculation'[Capacity Type]="INSTALLED",FILTER('Manning calculation','Manning calculation'[Value]<>0),'Manning calculation'[Values]="Avl Qty").

I am trying to get average for the above measure .

I am trying to use below measure to get avg

avg park=Averagex('Total_Machine_park')

i am getting Error. any idea.. thanks in advance .

Re: How to use average DAX function for measure

Jihwan_Kim — Fri, 08 Apr 2022 10:59:21 GMT

Hi,

Please try below.

Average measure: = AVERAGEX ( VALUES ( TableName[ColumnName_you want to measure avg] ), [Total_Machine_park] )

Re: How to use average DAX function for measure

tamerj1 — Sat, 16 Apr 2022 05:03:16 GMT

Hi Anonymous

how does your report look like? What columns are involved in the visual and in the slicers/filters and from which tables?