Solved: Can we calculate/show the 50% percentile

nazishm · ‎11-29-2022

Can we calculate 50% percentile of values in a particular column and plot it in Y-axis alone.
Can anyone help me with this

v-xiaotang · ‎12-01-2022

Yes, you can try this solution,

create the measure below

50% value = 0.5* MAX('Table'[value])

in measure, you need to use the aggregation functions to get the value in current row, which are max(), min(), selectedvalue().

Best Regards,

Community Support Team _Tang

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

v-xiaotang · ‎12-01-2022

Yes, you can try this solution,

create the measure below

50% value = 0.5* MAX('Table'[value])

in measure, you need to use the aggregation functions to get the value in current row, which are max(), min(), selectedvalue().

Best Regards,

Community Support Team _Tang

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

NikhilChenna · ‎11-29-2022

The simple way to achieve it is by creating a calculated measure.

go through this link for more detailed explanation.

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

Can we calculate/show the 50% percentile