Percentile Column with group by

Hi AlanPhan ,

 ^{Maybe you can create a new measure in the table , the code is as follows:}

Measure 2 = CALCULATE(PERCENTILE.INC('Table'[value],SELECTEDVALUE('Table'[Percentile])),'Table'[Percentile]=SELECTEDVALUE('Table'[Percentile]),ALL('Table'))

))

^{Then add a ‘Table’  visual and put ‘col1’ ‘col2’ ‘percentile’ fields and measure2 to the table, the output is as follows:}

^{This is the median I calculated for each group, whether it meets your needs, I found that the median calculated by the second group is different from the result in the picture you provided, could you provide the calculation logic?}

 If your Current Period does not refer to this, please clarify in a follow-up reply.

^{Best Regards,}

^{Yolo Zhu}

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