Incremental Average single points of sale

[Syndicate_Admin]

Hello tod@s

I'm trying to create a measure from a sales base that allows me to see the following:

with 1 SKU to how many PDVs on average I get

with 2 SKUs to how many PDVs on average I get....

and so for 3, 4, 5 SKUs

I intend to put together a table like the following, where the average value for SKU 2 is the average of unique PDVs between SKU1 and SKU2... (15+9)/2 = 12 and so...

Put together a DISTINCTCOUNT(BD[CLIENT]) measure that tells me the unique customers/POS but I don't know the incremental average.

Thank you!

[onurbmiguel_ · Accepted solution]

Hello Syndicate_Admin

My Sugestion for the measure:

Promedio incremental SKU = 
// to difine de min of SKU
var _SKU_ID = min('Table'[SKU])
//calcualte the average considerating the min of SKU
var _values = 

    CALCULATE(
        AVERAGE('Table'[Cantidad de PDV]),FILTER(ALL('Table'),'Table'[SKU]<=_SKU_ID))

return 

//to control if SKU is filtered or not
if(
    ISFILTERED('Table'[SKU]),
    _values,
    BLANK()
)

the output:

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Best Regards
BC