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 )
danextian
Super User
Super UserIs Item a separate column from SKU/High Level Category? And the average is based on the sum of each item divided by the number of unique items like below?
| Item | Value | Row Count |
| Item10 | 790 | 20 |
| Item19 | 40 | 5 |
| Item02 | 42 | 16 |
| Average | 290.67 |
parry2kSuper 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