Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |