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