cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
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
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

View solution in original post

4 REPLIES 4
Highlighted
Resolver IV
Resolver IV

Re: average problem!

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?

Highlighted
Helper III
Helper III

Re: average problem!

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

 

initial             sales

ad                   1000

dgl                  500

 

Then the average shall be 750

 

Highlighted
Resolver IV
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

View solution in original post

Highlighted
Helper IV
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' ) ))

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

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

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors