Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Can we calculate 50% percentile of values in a particular column and plot it in Y-axis alone.
Can anyone help me with this
Solved! Go to 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
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.
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
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.
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!
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
47 | |
33 | |
24 | |
19 | |
14 |