Forum Discussion
Get Calculation based on the Filtered Selection
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?
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()))
2 Replies
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()))