Forum Discussion
Comparing SKU average with Category Average
Hello, I'm reaching to you because I've encountered some problem I have hard time to solve. Either is really simple and I cannot come up with solution or it's pretty tricky. I want to calculate ...
Anonymous try this measure, it will get you what you are looking for.
Would appreciate Kudos 🙂 if my solution helped.
AVG_CAT_LOW = VAR __low = MAX ( searchspring[Category Low] ) RETURN CALCULATE( [AVG_SKU], ALL ( searchspring[SKU], searchspring[Category Low]), searchspring[Category Low] = __low )
parry2k
Super User
Super UserAnonymous try this measure, it will get you what you are looking for.
Would appreciate Kudos 🙂 if my solution helped.
AVG_CAT_LOW =
VAR __low = MAX ( searchspring[Category Low] )
RETURN
CALCULATE(
[AVG_SKU],
ALL ( searchspring[SKU], searchspring[Category Low]),
searchspring[Category Low] = __low
)
Thank you, works flawless! parry2k