How to get rid of Average in measure in power bi

[dunnalahk123]

Hi,

i am writing below dax query in my power bi application

Test = CALCULATE(average (GSD_CC_LAER_MODEL_YTD[Numerator]),GSD_CC_LAER_MODEL_YTD[Metric]= "E2E Resolution Time Onsite")

but what happening here is it is doing average of average i guess.

because when i get data from backend it is already grouped and average and provided me values on that if i wrote above function it is not matching with my database values.

i want to show values just the field as it is with out any aggregration.

i am using KPI card in power bi

[dunnalahk123]

Hi,

From backend i am already getting values after doing average so when i do average at powerbi front end it giving me wrong values. so i want to write expression with out any aggration to give just field value as it is.

[dunnalahk123]

Hi,

Basically I want to write expression with out any aggregation. It should just take values from my field as it is .

[sandeephijam]

hi dunna,

Please check your dax expression

normally average dax syntax only take one argument or parameter i. e. AVERAGE(<column>)

ref : AVERAGE function (DAX) - DAX | Microsoft Learn