Forum Discussion
ngiam
Helper I
Helper IHelp needed with DistinctCount & Average
Dear All, I want to create a card that shows the; Count number of Employee who has less than Average Sales of $100 for Client from Category Main (Refer to table below) Count number of Employe...
ValtteriN
Community Champion
Community ChampionHi,
Your formula was quite close. This counts the number of employees with whose average sales are less than 100 (customerCategory = "Main"):
AverageTest = calculate(DISTINCTCOUNT(Sales[Employee Name]),
filter(Sales,AVERAGEX(FILTER(Sales,RELATED(ClientCategory[Category])="Main"),Sales[Sales ])<100))
For secondary count replace "Main" with "Secondary".
I hope this helps and if it does consider accepting this as a solution and giving the post a thumbs up!
For secondary count replace "Main" with "Secondary".
I hope this helps and if it does consider accepting this as a solution and giving the post a thumbs up!