Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

DAX

Good morning! I need your help with calculating 99 persentile for values for a changing time period. I select a date range in the slicer and the persentile for that time in the table should be calculated. I tried creating a measure with the formula "Percentile = PERCENTILE.INC('public history'[Value], 0.99)" but I need to end up with a single value, not for each point in time from that date range.

I'm counting on your help!

 

Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    Hi Anonymous -adjust measure to calculate a single 99th percentile value for a selected date range in Power BI

     

    Percentile99 =
    VAR SelectedValues =
    CALCULATETABLE(
    'public history',
    ALLSELECTED('public history'[Date])
    )
    RETURN
    PERCENTILEX.INC(SelectedValues, 'public history'[Value], 0.99)

     

    Hope this approch works, check it.

1 Reply

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

    Hi Anonymous -adjust measure to calculate a single 99th percentile value for a selected date range in Power BI

     

    Percentile99 =
    VAR SelectedValues =
    CALCULATETABLE(
    'public history',
    ALLSELECTED('public history'[Date])
    )
    RETURN
    PERCENTILEX.INC(SelectedValues, 'public history'[Value], 0.99)

     

    Hope this approch works, check it.