Forum Discussion

pierredelareux's avatar
pierredelareux
Icon for Helper I rankHelper I
9 years ago

Calculate Grouped Percentage

Hi,   Please find bellow a screen-shot of my table. I would like to create a chart that gives me the reprensatation of the followings fields : % of (UR/Non_Exclus) by Territoire by month % of (...
Need Help
Show and Tell
Tutorial Requests
v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

pierredelareux

 

You can create a measure with following formula.

Ps: I named the table tas Table15.

 

UR/Non_Exclus =
CALCULATE ( DIVIDE ( SUM ( Table15[UR] ), SUM ( Table15[NON_EXCLUS] ) ) )

 

Best Regards,
Herbert

  • pierredelareux's avatar
    pierredelareux
    Icon for Helper I rankHelper I
    9 years ago

    Hi v-haibl-msft,

     

    It's not perfect because your formula calculate the Nen-Exclus sum for each month.

    in my data Non-Exclus are defin once for all. 

     

    Thanks for your feedback.

     

    Pierre

    • v-haibl-msft's avatar
      v-haibl-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      pierredelareux

       

      Maybe you’d like to sum Non_Exclus just by Territoire or by Site? Here is the solution.

       

      UR/Non_Exclus =
DIVIDE (
    SUM ( Table15[UR] ),
    CALCULATE (
        SUM ( Table15[NON_EXCLUS] ),
        ALLEXCEPT ( Table15, Table15[Territoire], Table15[Site] )
    )
)

       

       

      Best Regards,
      Herbert