Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
BiBra
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

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
Anonymous
Not applicable

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

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?

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

 

initial             sales

ad                   1000

dgl                  500

 

Then the average shall be 750

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.