Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

Measure Average



I am calculating Sales Rate using the formula- Sum of Table1[Amt]/ Sum of Table2[Amt]

If either of the amt is zero, I have to show blank which is what I am doing using the current measure

Sales Rate=IFERROR([A]/[B], BLANK())

where A- Sum of Table 1[Amt]

B- Sum of Table 2[Amt]

when I am selecting multiple date range, I am not getting average value. How do I calculate average for a measure in this scenario?


Thanks in advance.





According to your description, you want to calculate average baesd on the result of a calculated measure on row level. Right?

Since your calculation need to be evaluated on each row, you should put your calculated measure expression into AVERAGEX() function.


Sales Rate = AVERAGEX('Table',IFERROR([Measure 1]/[Measure 2],BLANK()))




Not applicable

Hi @v-sihou-msft


Thanks for replying. What is happening in this current context is, If I select 2016 and 2017 in my year slicer for the month of Jan, it is calculating Sum of (Table1)Amount for Jan 2016 + Sum of (Table1)Amount for Jan 2017/Sum of (Table2)Amount for Jan 2016+ Sum of (Table2) Amount for Jan 2017.


What I would like is Rate1= Sum of (Table1)Amount for Jan 2016/ Sum of (Table2)Amount for Jan 2016

Rate 2= Sum of (Table1)Amount for Jan 2017/ Sum of (Table2)Amount for Jan 2017

then Final Rate= (Rate 1+ Rate 2)/2


I tried using the solution that you provided, but I am confused what to use in "Table". I used Date table since it is given relationship with both Tables. Not getting desired result.


Thanks in advance.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors