Can we calculate/show the 50% percentile

[nazishm]

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 · Accepted solution]

Hi @nazishm 

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(). 

SELECTEDVALUE function - DAX | Microsoft Learn

SELECTEDVALUE – DAX Guide

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]

Hi @nazishm ,

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

go through this link for more detailed explanation. 

https://www.youtube.com/watch?v=TeFQstHX8Fs

Regards,

Nikhil Chenna

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