Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
nazishm
Regular Visitor

Can we calculate/show the 50% percentile

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

nazishm_0-1669787340182.png

 



1 ACCEPTED SOLUTION
v-xiaotang
Community Support
Community Support

Hi @nazishm 

Yes, you can try this solution,

create the measure below

 

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

 

vxiaotang_0-1669884782010.png

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.

View solution in original post

2 REPLIES 2
v-xiaotang
Community Support
Community Support

Hi @nazishm 

Yes, you can try this solution,

create the measure below

 

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

 

vxiaotang_0-1669884782010.png

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
Continued Contributor
Continued Contributor

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!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors