Get Calculation based on the Filtered Selection

[Anonymous]

Hi,

I'm trying to calculate Outliers by IQR method for which I need to first calculate Quartile 1 and Quartile 3 for the below data.

Store	Brand	Qty_ordered
1	A	162
2	A	119
3	A	132
4	A	152
5	A	142
1	B	148
2	B	126
3	B	151
4	B	195
5	B	153
6	B	113
1	C	171
2	C	183
3	C	200
4	C	136
5	C	142
6	C	180

I have a filter on the brand, which when selected I want the Quartile 1 and Quartile 3 for that particular brand, else it has to be for all the brands. 

Quart1 = CALCULATE(PERCENTILE.INC('[total_qty_ordered],0.25),IF(ISFILTERED([brand_label]),[brand_label]=[brand_label]),AllSelected()))

I thought of this, but "[brand_label]=[brand_label]" this part is giving an error. what do I do?

[amitchandak · Accepted solution]

@Anonymous , use selected value or max

CALCULATE(PERCENTILE.INC([total_qty_ordered],0.25),IF(ISFILTERED([brand_label]),filter(Table[brand_label]=selectedvalue([brand_label])),AllSelected()))

[Anonymous]

Filter works with table, not able to work with a column

also AllSelected() is not taking in if function