Average of measures

[Alosat]

Hello All,

Is it possible to somehow create an average of created measures?

I have a dashboard calculating Data Quality Indicators: 15 KPI`s in percentage (#correct/#total)

Now I would like to get a Data Quality index that will be an average of those 15 checks is there a formula I can use?

would like to show the Quality index in different groupings  by

Country,

Business

HR responsible

Currently, I`m just using (kpi1 + KPi2+... KPI15) /15 but starting the new month there will 16 of them so I for old months I want to keep 15 and new as 16

Cheers,

Maciek

[v-easonf-msft]

Hi, @Alosat 

Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.

You  can also  refer to these related threads to use averagex as below:

Measure= AVERAGEX ( SUMMARIZE ( Table, Table[Country] , "Measure",[YourMeasure] ), [Measure])

https://community.powerbi.com/t5/Desktop/Average-of-measure/m-p/50935

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Average-from-calculated-measure/m-p/1327237

Best Regards,
Community Support Team _ Eason

[Alosat]

no, I extended my description to be more clear

[amitchandak]

@Alosat ,

Try like

Avaragex(Values(Table[country]),[measure])