Z score to Percentile in Live Data

[SO]

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? 

[v-jingzhang]

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

[SO]

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.