Forum Discussion

Sammy22's avatar
Sammy22
Helper I
2 years ago
Solved

Table with conditional quartiles

i have a table with discounts for countries. I want to calculate the quartile 1 of the region for the specific product and then the quartile 1 of all the countries regardless of region based on the p...
  • Sammy22's avatar
    Sammy22
    2 years ago

    Managed to find a solution. This is calculating the 75th percentile:

     

    75th Percentile Discount% = calculate(PERCENTILE.INC('Table'[Country_Discount%] ,0.75),ALLEXCEPT('Table',Table[PRODUCT]))
lbendlin's avatar
lbendlin
Super User
2 years ago

You would use PERCENTILEX for that.  Have you tried that?

 

Note that your data is insufficient for this. You need many more datapoints.