cancel
Showing results for
Did you mean:

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.

Helper II

## calculate the average of a measure

Good Morning

I need to calculate the average of a measure that can then be used in a line chart.

My table of values is as follows:

 Year Month Total 2022 January 1256 2022 February 848 2022 March 1021 2022 April 727 2022 May 954 2022 June 1055 2022 July 1134 2022 August 1708 2022 September 1800 2022 October 748 2022 November 781 2022 December 429 2023 January 1203 2023 February 852 2023 March 966 2023 April 580 2023 May 761 2023 June 318

I want to get the average of the total which should be 952. Total is a measure that is calculated using distinct count of person number.

Thank you

4 REPLIES 4
Helper II

The issue i am having is that the total is a count of person ref number, an example of which is 12234, so when i do average of person ref number it is not giving me the 952 i am expecting it is giving me over 3000.

Helper II

Thank you i have already tried that and it doesnt let me select the measure Total

Super User

Hello @maurcollins ,

oh this total is a measure in a visual, then you need to reference the main column that is in your dataset.

 Vote for my Community Mobile App Idea

Proud to be a Super User!

Super User

Hello @maurcollins,

You could use this measure
Average Total = AVERAGE(TableName[Total])

 Vote for my Community Mobile App Idea

Proud to be a Super User!

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors