Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
AlexPayette
Frequent Visitor

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

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.

 

1 REPLY 1
lbendlin
Super User
Super User

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.