Use Average of Bar Graph values in a Card (instead of their cumulative Sum)?

[wad11656]

I have a Card that shows me the sum of values from the visible bar graph ("Full-Time Billable Hours").

How do I get the average of their values instead? (aka Divide the bars' cumulative sum by how many of them are visible?)

(If only 1 bar is clicked on/highlighted, I want it to continue to only show that bar's value, aka divide by 1.)

[wad11656 · Accepted solution]

Well. With 'hbdg time_entry'[Hours] as my y-axis (which had to be a Measure for some reason), and 'hbdg time_entry'[Week Start Date]) as my x-axis, I did the following:

AverageBillable = AVERAGEX(ALLSELECTED('hbdg time_entry'[Week Start Date]),'hbdg time_entry'[Hours])