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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
dunnalahk123
Frequent Visitor

How to get rid of Average in measure in power bi

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
3 REPLIES 3
dunnalahk123
Frequent Visitor

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

Hi,

 

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

sandeephijam
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

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.