Forum Discussion
Solved
Creating Range Buckets using Average per Category ID
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[...
Hi anil,
That's because the "Allexcept" cleared the context. Please try the formula below or adjust it.
Avg Discount % = CALCULATE ( AVERAGE ( Sample[DISCOUNTPERCENT] ), ALLEXCEPT ( 'Sample', Sample[ID], 'Sample'[Order Date].[Year] ) )Best Regards,
Dale
Thanks Dale for the reply,
If we use the measure the average is constant even if we slice using the date. Which is incorrect.
Eg. If we filter ID say: E50XN and filter year = 2010 the Average remains the same 45.43, where the actual Average is 100.
What I understood is the created measure is not affected by the date slicer.
Please help me with solution. Tried different methods but unable to crack it.
Hi anil,
That's because the "Allexcept" cleared the context. Please try the formula below or adjust it.
Avg Discount % = CALCULATE ( AVERAGE ( Sample[DISCOUNTPERCENT] ), ALLEXCEPT ( 'Sample', Sample[ID], 'Sample'[Order Date].[Year] ) )Best Regards,
Dale
Thank You v-jiascu-msft