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.
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
Solved! Go to Solution.
@HarryB ,
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:
[Class Types 1-2]
, [Class Types 2-3]
, [Class Types 3-4]
, [Class Types 5-6]
) to the Values area of the line chart.Average_Class_Types
measure to the Values area as well.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.
Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI
You cannot measure a measure directly. Either materialize it first, or create a separate measure that implements the entire business logic.
@HarryB ,
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:
[Class Types 1-2]
, [Class Types 2-3]
, [Class Types 3-4]
, [Class Types 5-6]
) to the Values area of the line chart.Average_Class_Types
measure to the Values area as well.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.
Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
95 | |
80 | |
77 | |
66 |
User | Count |
---|---|
130 | |
106 | |
105 | |
86 | |
72 |