Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to 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
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
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
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
109 | |
105 | |
73 | |
71 |