Measure grouping

[Anonymous]

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!

[MFelix · Accepted solution]

Hi @Anonymous,

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

[Anonymous]

Perfect, 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!