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]))
Sammy22's avatar
Sammy22
Helper I
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]))
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks lbendlin for the helpful thoughts.

Hi Sammy22 ,

 

I'm going to make some additions to yours, here I've created two calculated columns:

Q1 Region = 
CALCULATE(
    PERCENTILE.INC('Table'[Country Discount], 0.25),
    ALLEXCEPT('Table', 'Table'[Region],'Table'[Product]))

Q1 Overall = 
CALCULATE(
    PERCENTILE.INC('Table'[Country Discount],0.25),
    ALLEXCEPT('Table','Table'[Product]))

The result is as follows:

 

Best Regards,
Zhu
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!