Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Measure grouping

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 ...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    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

MFelix's avatar
MFelix
Super User
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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!