I need to have the average of a measure but how can i do this?
In the image u can see what output i would like to achieve.
Solved! Go to Solution.
@vitoow can you paste the data in here rather than a pic?
Proud to be a Super User!
Hey what data u want me to give you? I would like to have the average of a measure but i can't seem to find a way to achieve this.
For example i got these columns
Budget | Sales | % Actuals |
1.971.793 | 132.412 | 6.7% |
3.397.666 | 234.819 | 6.9% |
1.152.450 | 87.791 | 7.6% |
1.323.337 | 154.675 | 11.7% |
460.306 | 55.207 | 12.0% |
The column "% Actuals" is a measure and i would like to have to average of this.
@vitoow how are you calculating that measure?
Proud to be a Super User!
The calculation happens through a few measures ill post them below
This is the measure i want to get an average from:
@vanessafvg First of all thanks for the effort you are putting in! But this isnt quite what i need
I need something like this
Budget | Sales | % Actuals |
1.971.793 | 132.412 | 6.7% |
3.397.666 | 234.819 | 6.9% |
1.152.450 | 87.791 | 7.6% |
1.323.337 | 154.675 | 11.7% |
460.306 | 55.207 | 12.0% |
The average of the column % Actuals would be 8,98%. I want to make something like this with the average
Budget | Sales | % Actuals | Average |
1.971.793 | 132.412 | 6.7% | 8,98% |
3.397.666 | 234.819 | 6.9% | 8,98% |
1.152.450 | 87.791 | 7.6% | 8,98% |
1.323.337 | 154.675 | 11.7% | 8,98% |
460.306 | 55.207 | 12.0% | 8,98% |
hi @vitoow what i mean is just paste the data in text, not the picture, otherwise i can't copy it out, so i can take the data and create the measure in power bi for you and paste it back
Proud to be a Super User!
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
User | Count |
---|---|
224 | |
48 | |
45 | |
44 | |
42 |
User | Count |
---|---|
274 | |
211 | |
82 | |
74 | |
63 |