Average of measure in a table

[Anonymous]

Hi Support,

The below are measures which I have created in PBI

Class Types 1-2 =
CALCULATE([User Learner Types],ga4_data[audience]="1-2")

Class Types 2-3 =
CALCULATE([User Learner Types],ga4_data[audience]="2-3")

Class Types 3-4 =
CALCULATE([User Learner Types],ga4_data[audience]="3-4")

Class Types 5-6 =
CALCULATE([User Learner Types],ga4_data[audience]="5-6")

1) What measure in dax can I create to get the average from these 4 measures and display them in a table

2) How can I get all all 4 measure on one Line chart graph as per below with the average as line number 5 which is the dotted graph

The bottom axis of the chart will have weeks and class types.

Thanks

[lbendlin]

You cannot measure a measure directly. Either materialize it first, or create a separate measure that implements the entire business logic.

[marcelsmaglhaes · Accepted solution]

@Anonymous ,

To achieve this in Power BI, you can follow these steps:

1 - Create a new measure to calculate the average of the four measures:
Average_Class_Types = (([Class Types 1-2]) + ([Class Types 2-3]) + ([Class Types 3-4]) + ([Class Types 5-6])) / 4

2 - Create a line chart with all four measures and the average measure:

1. • Place the dates or categories on the axis of the line chart.
   • Add the four measures ([Class Types 1-2], [Class Types 2-3], [Class Types 3-4], [Class Types 5-6]) to the Values area of the line chart.
   • Add the Average_Class_Types measure to the Values area as well.
   • Customize the visual as needed to display the lines with different colors/styles.
   • Ensure that the visual is showing the data as you expect, with all four measures and the average displayed correctly

This setup will give you a line chart with all four measures displayed as lines, and the average displayed as a fifth line. You can customize the visual further to adjust the colors, styles, and other formatting options as desired.

[Anonymous]

@marcelsmaglhaes  your solution worked well thank you