cancel
Showing results for
Did you mean:

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

## Measure Average

Hello,

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?

2 REPLIES 2  Microsoft

@Anonymous

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()))
``` Regards, Anonymous
Not applicable

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. Announcements #### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features. #### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator. #### 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
Users online (4,846)