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

The 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.

Reply
landcruiser64
Frequent Visitor

Showing monthly average unit price on chart

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.

1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

Hi @landcruiser64 

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:

7.png8.png

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.

View solution in original post

1 REPLY 1
v-juanli-msft
Community Support
Community Support

Hi @landcruiser64 

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:

7.png8.png

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.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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