cancel
Showing results for
Did you mean:
Highlighted
Helper III

## average problem!

Hello.

I am sitting with some data in a line and clustered column chart, where I want to show the average, represented as a line.

dummy data:

Initial           Sales value

dh                   1000

shg                  500

From these data, I would like a straight line in the chart, lying at 750 (average of sales).

However when I set sales value as a line, and choose average, it takes the average of each individual column.

meaning: there are two column: one for dh, showing average 1000, and one for shg showing 500.

Can anyone help?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver IV

## Re: average problem!

Hi @BiBra,

Craete a measure as below

Average Measure Calculated = (CALCULATE(SUM(you_table_name[Sales]))/DISTINCTCOUNT(you_table_name[Initial]))

If it works, please give a kudo and accept the solution

4 REPLIES 4
Highlighted
Resolver IV

## Re: average problem!

Hi @BiBra,

You want to take the average of each initial item ?

Initial | sales

abc    |  10

def     | 20

abc     | 30

averga eof bac is (10+30)/2 = 20

avergare of def os 20/1 = 20

is this is what you are looking for?

Highlighted
Helper III

## Re: average problem!

No, I want to make an overall average. Like said:

initial             sales

dgl                  500

Then the average shall be 750

Highlighted
Resolver IV

## Re: average problem!

Hi @BiBra,

Craete a measure as below

Average Measure Calculated = (CALCULATE(SUM(you_table_name[Sales]))/DISTINCTCOUNT(you_table_name[Initial]))

If it works, please give a kudo and accept the solution

Highlighted
Helper IV

## Re: average problem!

Hello,

I get the same problem...

Here is my issue :

http://community.powerbi.com/t5/Desktop/Daily-average/m-p/331657#M148282

Thanks to Zubair!

DIVIDE ( SUM ( [Sales value] ), CALCULATE (DISTINCTCOUNT ( [Initial] ), ALL ( 'Name of the table' ) ))

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021