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
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