Forum Discussion

Nihed's avatar
Nihed
Helper III
3 years ago
Solved

Percentage

Hello,

 

please how I can calculate the percentage of this column(a grades Headcount) ?

 

 

 

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Nihed ,

    Please have a atry.

    Create a measure.

    a row divide all = MAX('Table'[A Grade Headcount])/(SUMX(ALL('Table'),'Table'[A Grade Headcount]))

    Or a column.

    Column = 'Table'[A Grade Headcount]/(SUM('Table'[A Grade Headcount]))

     

     

    If I have misunderstood your meaning, please provide more details with the desired output and pbix file without privacy information.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Nihed ,

    Please have a atry.

    Create a measure.

    a row divide all = MAX('Table'[A Grade Headcount])/(SUMX(ALL('Table'),'Table'[A Grade Headcount]))

    Or a column.

    Column = 'Table'[A Grade Headcount]/(SUM('Table'[A Grade Headcount]))

     

     

    If I have misunderstood your meaning, please provide more details with the desired output and pbix file without privacy information.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.