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
Thursday - last edited Thursday
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.
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.