cancel
Showing results for
Did you mean:

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

Responsive Resident

## Average a total

Hello,

Hoping sopmeone can help me average a total.

I am trying to average the "AvgDailyChg" row.  I would greatly appreciate a solution to this problem!

I dont know if this will help, but I was given this formula from @Icey, but I do not know how to plug in my Fields or measures with the formula that I was given.  And I am not even suire if this forula will work, fyi.

```Measure =
IF (
NOT ( HASONEVALUE ( 'Table'[YearMonth] ) )
&& SELECTEDVALUE ( 'Table'[Product] ) IN { "B", "C" },
AVERAGE ( 'Table'[Value] ),
SUM ( 'Table'[Value] )
)```

Here are the fields I have for the dataset I am working with.

2 REPLIES 2
Solution Sage

Not clear,

if you help with more detail and a sample of it. I wiil try to help you out.

Regards,

Manikumar

If this helps, Appreciate your KUDOS!

Proud to be a Super User!

Responsive Resident

I think I am getting closer to my answer using the formula below.  I am trying to average the Total.  As you can see from the screen shot the Total is summing the 3 months.

Here is the formula I am currently using ...

Power BI Comm 2 =
IF (
(
NOT ( HASONEVALUE ( 'DateOfServiceAnalysis'[MTHYear_Sort] ) )
&& SELECTEDVALUE ( 'DateOfServiceAnalysis'[MTHYear_Sort] ) IN { "AvgDailyChg" }
)
|| (
NOT ( HASONEVALUE ( 'DateOfServiceAnalysis'[MTHYear_Sort] ) )
&& NOT ( HASONEVALUE ( 'DateOfServiceAnalysis'[AvgDailyChg] ) )
),
AVERAGE ( 'DateOfServiceAnalysis'[AvgDailyChg] ),
SUM ( 'DateOfServiceAnalysis'[AvgDailyChg] )
)

Here is the formula I was provided from @Icey via the Power Bi Community...
```Measure =
IF (
(
NOT ( HASONEVALUE ( 'Table'[YearMonth] ) )
&& SELECTEDVALUE ( 'Table'[Product] ) IN { "B", "C" }
)
|| (
NOT ( HASONEVALUE ( 'Table'[YearMonth] ) )
&& NOT ( HASONEVALUE ( 'Table'[Product] ) )
),
AVERAGE ( 'Table'[Value] ),
SUM ( 'Table'[Value] )
)```

If you do provide an answer it would be extremely helpful to me if you could also provide the Fields to fill in for the formula.
For example, which Field I should be using for "Value", "Product", "B" and "C", etc.

Thank you so much 🙂

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