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
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.