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
SO
Helper III
Helper III

Z score to Percentile in Live Data

What to do when a PowerBI function does not work? 
I have been able to manually calculate Z scores for my data, but now I'm looking to dynamically show the percentiles of the data set.  A number of functions do not work while using data In Service (Live Data).  Functions like Percentile.inc for example do not work with Live data.  I am trying to show something like ( Percentiles are only example data).

 

Data                  Z Score     mean       SD         Percentile

Location A            0             .22          0.23            50 %

Location B           -1             .22          0.23         15.87 %

Location C            1             .22           0.23         84.13 %

Location D            2.5          .22           0.23         99.38 %

 

In my organization, I am trying to show that just becuase one location or event is ranked next to another, does not mean they are similiar.  Z scores are really helping show the outliers, but I also need to for folks to see the context.  Help?  I know I will need to work through the Z score to address.  
thoughts? 

 

2 REPLIES 2
v-jingzhang
Community Support
Community Support

Hi  @SO 

 

What do you refer to with "Live Data"? How do you use those DAX functions? 

 

The syntax of PERCENTILE.INC for example is PERCENTILE.INC(<column>, <k>). The first parameter is required to be a column. Do you want to use Z Score for the first parameter? Is your Z Score a column or a measure? And what is the percentile value you want to pass to the second paramter k? 

 

Here is the doc for PERCENTILE.INC: https://dax.guide/percentile-inc/ 

 

Best Regards,
Community Support Team _ Jing

Thanks.  From https://docs.microsoft.com/en-us/dax/percentile-inc-function-dax?WT.mc_id=DP-MVP-4025372, they note:  

  • This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

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