Forum Discussion
Looking for Average %
Hello,
I have a matrix with seven colleagues names and their respective metric % based on the total # of 'seekers' (it'll make sense once you see the chart below).
Anyways, The % is what I am focusing on. The matrix is automatically adding them up - showing 27.03% ( have 5 colleagues excluded/filtered out - just FYI), I need the average % between all seven, so 4.76% to show.
Each % is basically # of seekers referred / distinct seeker referrable students.
I don't need to have it in the column, I can have the value in a card or separate visual, but what is the easiest way to do this?
1 Reply
Try this and please click the Accept Solution button AND the thumbs up button to leave kudos. Thank you
% Seekers Refered =IF(HASONEFILTER(Facts[Colleague]),DIVIDE(SUM(Facts[Referred]),SUM(Facts[Students])),AVERAGEX(VALUES(Facts[Colleague]),CALCULATE(DIVIDE(SUM(Facts[Referred]),SUM(Facts[Students])))))
