Calculating Percentile from a Measure (Sum of a column and filters)

[AlexPayette]

Hi, I have an issue regarding a measure I am trying to create in DAX. What I wanna be doing, is calculating the 85th percentile of a measure that is the sum of a column and that implied filters and conditions in it. 

This is what my initial measure looks like : 

CALCULATE(SUM(Issues[Story Points]),

        FILTER(StatusCategory,StatusCategory[Status Category Name] = "Done"),

        FILTER(IssueTypes,IssueTypes[Issue Type Name] IN {"bug", "story", "spike"}),

        FILTER(Issues,Issues[FK LastSprintId] = MIN(Issues[FK LastSprintId])),

        USERELATIONSHIP(Issues[Status Category Change Date],'Date'[Date])

    )

So what I wanna be doing, is based on this measure and those filters and conditions, I wanna be calculating a percentile based on this measure. The problem is because the percentile measure is working with columns and not measure, and I wanna have a sum of the column (Story Points), I can't seem to make the percentile function works.

This is what I tried to do, it doesn't work for all my data cases : 

CALCULATE(

    PERCENTILEX.INC(

        VALUES(Boards[Board Name]),

        CALCULATE(SUM(Issues[Story Points])),

        0.85

    ),

    FILTER(StatusCategory,StatusCategory[Status Category Name] = "Done"),

    FILTER(IssueTypes,IssueTypes[Issue Type Name] IN {"bug", "story", "spike"}),

    FILTER(Issues,Issues[FK LastSprintId] = MIN(Issues[FK LastSprintId])),

    USERELATIONSHIP(Issues[Status Category Change Date],'Date'[Date])

)

I looked a little bit and was wondering if I should maybe use the Summarize function, but wasn't sure at all.

Let me know if someone can help me with my calculation.

Thank you.

[lbendlin]

calculating the 85th percentile of a measure 

You cannot measure a measure. Implement the entire logic in a new measure.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...