Can we calculate 50% percentile of values in a particular column and plot it in Y-axis alone. Can anyone help me with this
Go to Solution.
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
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Hi @nazishm ,
The simple way to achieve it is by creating a calculated measure.
go through this link for more detailed explanation.
Appreciate with a Kudos!! (Click the Thumbs Up Button)Did I answer your question? Mark my post as a solution!
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.