Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Divide % Calculation

Hi Experts,

This is my Table

 

Below is the  measure for  AUM Introducer Count 1, but I dont know how to create  measure for AUM Band %_1. 

Anyone Please help.

 

Thank you,

 

Re

Need Help
Show and Tell
  • TheoC's avatar
    TheoC
    4 years ago

    Hi Anonymous 

     

    You can create Calculated Column as per below or replicate using measures.

     

    % = 

    VAR _SumAum = SUM ( 'Table (2)'[AUM Introducer Count_1] )
    VAR _SumAumGroup = CALCULATE ( SUMX ( 'Table (2)' , 'Table (2)'[AUM Introducer Count_1] ) , ALL ( 'Table' ) )

    RETURN 

    _SumAumGroup / _SumAum

     

     

    Hope this helps 🙂

     

    Theo 

1 Reply

  • TheoC's avatar
    TheoC
    Community Champion
    4 years ago

    Hi Anonymous 

     

    You can create Calculated Column as per below or replicate using measures.

     

    % = 

    VAR _SumAum = SUM ( 'Table (2)'[AUM Introducer Count_1] )
    VAR _SumAumGroup = CALCULATE ( SUMX ( 'Table (2)' , 'Table (2)'[AUM Introducer Count_1] ) , ALL ( 'Table' ) )

    RETURN 

    _SumAumGroup / _SumAum

     

     

    Hope this helps 🙂

     

    Theo