- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

# Simple Average

[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-10-2018 06:58 AM - edited 12-16-2018 06:12 AM

## Help with AVG formula

[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-09-2018 12:15 PM - edited 12-16-2018 06:13 AM

Category_Breakdown ties to Total_Score and that is correct. However, the Category_Breakdown2 (the formula you shared) is giving me the same results as Category_Breakdown. However, I need this to be the same for the new AVG formula that I am leveraging.

I think this all has something to do with the AVG formula that I am using to simply get a straight average. I need my percentage breakdown to work using a similar functionality. I need the breakdown to also be a simple AVG.

## Re: Help with AVG formula

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-11-2018 12:16 AM

@nmck86,

I am not clear about your expected result. Could you please elaborate more about the desired result based on the PBIX file?

Regards,

Lydia

If this post

**helps**, then please consider

**to help the other members find it more quickly.**

*Accept it as the solution*## Re: Simple Average

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-11-2018 01:13 AM

Hi nmck86,

"When I do the math of **happy-mad** I expect **Category_Breakdown**to tie to **Total_Score** and it does! However, I need this to be the same for the new AVG formula that I am leveraging. I need my **AVG formula** to tie back to the **Category Breakdown2**"

<--- Your requirement is not so clear, could you please clarify more details about your logic and what you want to achieve? For example, are you doubting whether result of [AVG] is different from [Total_Score]?

Regards,

Jimmy Tao

## Re: Help with AVG formula

[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-11-2018 04:16 AM - edited 12-16-2018 06:14 AM

## Re: Simple Average

[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-11-2018 04:19 AM - edited 12-16-2018 06:15 AM

I would like for my results below to total 19.06% instead of 27.24%. Since some months do not have values my formula is excluding those records. In this case it would be divided by 10 because there are only 10 months but it will change every month depending on the months selected. For instance next month it will be 12 months of data even if all months do not have values I need the data to divide by the full 12 months for the average.

Current formula:

AVG_Category_Breakdown =

AVERAGEX(SUMMARIZE(VALUES('download to use'[Month]),[Month],"ABCD",[Category_Breakdown]),[ABCD])

## Help getting an AVERAGE to include blank values for some months

[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-11-2018 05:40 PM - edited 12-16-2018 06:16 AM

I have a measure in power bi that has the % breakdown for a particular category and after I get that I am attempting to create an average. This average however is excluding the months without values. Is there a way to get Power BI to include those months with no values? In the below example I am expecting to see 19.07 or close to that.

It may require a date_dim tbl that I didnt create in the file I am sharing but wanted to give an example quickly.

## Re: Help getting an AVERAGE to include blank values for some months

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-11-2018 05:45 PM

FYI, I can't open the file. What version did you author it with? I tried to open with latest (December) version of Power BI Desktop.

## Re: Help getting an AVERAGE to include blank values for some months

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-11-2018 05:54 PM

I just updated and confirmed this is on the Dec 2018 version of Power BI.

https://drive.google.com/file/d/1siXptcM3FGuvQ3VH4qbC3aBdgFUa0Dgl/view?usp=sharing

## Re: Help getting an AVERAGE to include blank values for some months

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-11-2018 06:10 PM

OK, I got it open.

I can't figure out why you want the average to be around 19. It looks correct as it is.

13.76/80.30 = 17.13%

How do you get the result you're expecting?