Forum Discussion

Sammy22's avatar
Sammy22
Helper I
1 year 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
    1 year 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
1 year ago

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

 

CountryRegionProductCountry DiscountQ1 RegionQ1 Overall
ChinaEastern AsiaA0.54  
KoreaEastern AsiaB0.52  
JapanEastern AsiaC0.51  
TaiwanEastern AsiaA0.62  
SloveniaSouthern EuropeB0.69  
HungaryEastern EuropeC0.55  
Czech RepublicEastern EuropeA0.49  
PolandEastern EuropeB0.43  
SlovakiaEastern EuropeC0.53  
RomaniaEastern EuropeA0.7  
BulgariaEastern EuropeB0.66