Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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
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' ) ))
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
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |