Percentile.INC for categories and dates dynamically

Hi Anonymous ,

Many thanks for the reply, appreciate it,

So let me explain, the request is to create 4 measures which will show accordingly 25th, 50th, 75th and 90th percentile. Each plant have its complexity, and also we have a timeline filter, so the aim is to filter by time and the complexity. For instance: when I choose last 6 months and no complexity then measure should calculate 25th percentile for whole organisation for last 6 months, but when I choose last 6 months AND the complexity low, I should see what is the 25th percentile for those plants which are low. The percentile measures will be put into the column chart and line chart (percentiles as lines, the value should be constant across the company and related to filters of complexity and timeline). Important thing is that if only one plant is chosen, the measure should calculate percentile only to the level of complexity, not plant.

Currently I am using the percentile from the analysis tab of the visual, but when plant is chosen, it shows the percentile for this certain plant and not for the complexity.

This should look like below, where in the X-Axis we have plants and the Y-Axis is the mentioned calculation:

Measure =
DIVIDE(CALCULATE(SUM('table2'[Cases])) * 200000,CALCULATE(SUM('table2'[Hours])))

If anything more is necessary let me know, 

Greetings!