12-06-2018 02:02 AM
Below is the table with year and corresponding volume on Global level
Another table with volume based on region and Column - Value in this table is calculated as NACA Volume/Total Volume * 100 (I am calculating this in a measure)
Now I need to calculate the result as below, percentile should be 10th percentile
Formula for Percentile should be PERCENTILE.INC(Value,0.1) i.e, PERCENTILE.INC(7.7:5.8,0.1) = 5.99
I could not pass the range of values which is calculated in a measure into percentile function in DAX.
Please help me to calculate this
12-06-2018 06:30 PM - edited 12-06-2018 06:32 PM
In order to achieve your goal you should to use calculated columns instead Value measure.
See these images and tell us if work for you.
12-07-2018 02:43 AM
Thank you for your response. I cannot use calculated column because, I have shown only the aggregated data in example. In Actual data I have records as below. So I need percentile for Regionwise i.e NACA, and I need to slice by year and percentile should chanage accordingly.