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, I'm pretty new to power bi and dax, but haven't had luck with finding an example that fits what I'm trying to do.
I'm trying to get the following - I've created a new measure as shown in the image below. I've put the results into a matrix with Event as columns and Team as rows and the values come out fine, however what I want for the total column for each team is the Average of Events as opposed to performing the measure without respect to the events.
I think I need some combination of Calculate, Group By or summarize, but I haven't been able to wrap my head around how to get what I want. Any help would be welcome!
Solved! Go to Solution.
Hi @xarius,
Create the following two measures:
Percent_Team = DIVIDE ( SUM ( 'Table'[T1] ); SUM ( 'Table'[T1] ) + SUM ( 'Table'[T2] ) ) Total Percent = IF ( HASONEVALUE ( 'Table'[Event] ); [Percent_Team]; AVERAGEX ( SUMMARIZE ( 'Table'; 'Table'[Team]; 'Table'[Event]; "Average_Total"; [Percent_Team] ); [Average_Total] ) )
Then use your second measure to create your table visual:
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @xarius,
Create the following two measures:
Percent_Team = DIVIDE ( SUM ( 'Table'[T1] ); SUM ( 'Table'[T1] ) + SUM ( 'Table'[T2] ) ) Total Percent = IF ( HASONEVALUE ( 'Table'[Event] ); [Percent_Team]; AVERAGEX ( SUMMARIZE ( 'Table'; 'Table'[Team]; 'Table'[Event]; "Average_Total"; [Percent_Team] ); [Average_Total] ) )
Then use your second measure to create your table visual:
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsPerfect, thank you!
I thought I had to do it in one stage, but this makes sense and really helps me understand the summarize function too!
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |