Creating Range Buckets using Average per Category ID and Filtering By Date

Hi,

      My dataset has ID's with multiple orders. I am trying to calculate average discount across orders per ID.

Avg Discount % = CALCULATE(AVERAGE(Sample[DISCOUNTPERCENT]),Sample,VALUES(Sample[ID]))

And creating a column to bucket the averages of ID's.

Bucket = Switch ( True(),
                           And( [Avg Discount %]>=-10 ,[Avg Discount %] < Sample[Fixed TMax Var 5%]) , "Green",
                           And( [Avg Discount %]>=Sample[Fixed TMax Var 5%],[Avg Discount %] < Sample[Fixed TMax Var 15%]) , "Yellow",
                           And(  [Avg Discount %] >= Sample[Fixed TMax Var 15%],[Avg Discount %] < 500),  "Red"
                         )

But The result I am getting from the calculate column Bucket is incorrect.

The dataset has 49 ID's, But in the Bucket range, it is showing 46+14 = 60 which is incorrect.

Please help me to achieve the expected result.