average problem!

[BiBra]

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? 

[Anonymous]

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' ) ))

[mehaboob557]

Hi @BiBra,

Please help me understand your problem.

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?

[BiBra]

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

initial             sales

ad                   1000

dgl                  500

Then the average shall be 750

[mehaboob557 · Accepted solution]

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