Forum Discussion
Comparing SKU average with Category Average
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 )
Thank you but in your calculation the only difference is the sum function and divide changed for average which does not help at all. I don't need to calculate average based on the count of rows but on the number of items.
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 |
- parry2k
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 )Thank you, works flawless! parry2k
If I understand you correctly i think that is separate.
Average is calculate by the sum of value for item divided by column with number of items