Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I need help writing a DAX for a single KPI for Average Monthly Units. Average, AverageA, AverageX seem to show the average across all the data, but I need the Average for all of the Months in the dataset in 1 KPI.
I have Total Units and Order Date, how would I write a DAX for Average Monthly Units for a KPI. Not in a Chart but a single KPI.
So I need to calculate the # of Months in the Period of the datest and then the average for each month and then the average for all of those.
Solved! Go to Solution.
Please show an example data and expect result.
For example,
Example data:
date | units |
1/1/2018 | 1 |
1/2/2018 | 2 |
1/3/2018 | 3 |
1/4/2018 | 4 |
1/5/2018 | 5 |
1/6/2018 | 6 |
1/7/2018 | 7 |
1/8/2018 | 8 |
In Power BI, Create a measure,
average = CALCULATE(AVERAGE(Table1[units]),ALLSELECTED(Table1))
add it in a KPI, it shows a result as below:
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please show an example data and expect result.
For example,
Example data:
date | units |
1/1/2018 | 1 |
1/2/2018 | 2 |
1/3/2018 | 3 |
1/4/2018 | 4 |
1/5/2018 | 5 |
1/6/2018 | 6 |
1/7/2018 | 7 |
1/8/2018 | 8 |
In Power BI, Create a measure,
average = CALCULATE(AVERAGE(Table1[units]),ALLSELECTED(Table1))
add it in a KPI, it shows a result as below:
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
121 | |
69 | |
66 | |
56 | |
52 |
User | Count |
---|---|
181 | |
85 | |
67 | |
61 | |
53 |