Forum Discussion

Klasia's avatar
Klasia
Frequent Visitor
1 month ago
Solved

How show quantile in matrix

Hi, I have a table containing data with information about the task date, category, task ID, and task duration. Date Category ID Time 2026-01-01 A 32548A 422593 2026-07-10 A 10349C...
Need Help
  • pankajnamekar25's avatar
    pankajnamekar25
    1 month ago

    Hello Klasia 

    PERCENTILE.INC interpolates, so it returns a synthetic value that doesn't actually exist in your data. To get the real row closest to that threshold, build a virtual table inside the measure (SUMMARIZE) it's used only for the calculation, never touches the visual, so no extra rows or slowdown.
    Quantile Actual Duration =
    VAR Threshold = PERCENTILE.INC('Table'[Time], 0.25)
    VAR VirtualTable =
    SUMMARIZE(
    'Table',
    'Table'[ID],
    "@Time", CALCULATE(MAX('Table'[Time]))
    )
    VAR ClosestRow =
    TOPN(1, VirtualTable, ABS([@Time] - Threshold), ASC)
    RETURN
    MAXX(ClosestRow, [@Time])

     

     


    If my response helped you, please consider clicking
    Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.

    Thanks,

    Connect with me on:
    LinkedIn |
    Data With Pankaj - YouTube

     

v-achippa's avatar
v-achippa
Community Support
1 month ago

Hi Klasia,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you pankajnamekar25, Ritaf1983 and Prince0011 for the prompt response.

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked?  or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa