Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Frequent Visitor

How to get rid of Average in measure in power bi



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
Frequent Visitor



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.

Frequent Visitor



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

Helper I
Helper I

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

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.