Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    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()))

amitchandak's avatar
amitchandak
Super User
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

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

     

    also AllSelected() is not taking in if function