Table with conditional quartiles

[Sammy22]

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. 

Country	Region	Product	Country Discount	Q1 Region	Q1 Overall
China	Eastern Asia	A	0.54
Korea	Eastern Asia	B	0.52
Japan	Eastern Asia	C	0.51
Taiwan	Eastern Asia	A	0.62
Slovenia	Southern Europe	B	0.69
Hungary	Eastern Europe	C	0.55
Czech Republic	Eastern Europe	A	0.49
Poland	Eastern Europe	B	0.43
Slovakia	Eastern Europe	C	0.53
Romania	Eastern Europe	A	0.7
Bulgaria	Eastern Europe	B	0.66

[Sammy22 · Accepted solution]

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]

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!

[Sammy22]

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. 

Country	Region	Product	Country Discount	Q1 Region	Q1 Overall
China	Eastern Asia	A	0.54
Korea	Eastern Asia	B	0.52
Japan	Eastern Asia	C	0.51
Taiwan	Eastern Asia	A	0.62
Slovenia	Southern Europe	B	0.69
Hungary	Eastern Europe	C	0.55
Czech Republic	Eastern Europe	A	0.49
Poland	Eastern Europe	B	0.43
Slovakia	Eastern Europe	C	0.53
Romania	Eastern Europe	A	0.7
Bulgaria	Eastern Europe	B	0.66

[lbendlin]

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

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