Convert Measure

[Userpath77]

Hello All

I am working on a co-workers dashboard and trying to make a fix. I have a stacked column chart using this measure as Values:

Average Employee per listing date = AVERAGEX(KEEPFILTERS(VALUES('Historical Employee Listing'[Listing Date])),

CALCULATE(COUNTA('Historical Employee Listing'[Name])))

My Main problem is that I need to show this in a "Legend." Unfortunately I can't put the measure in a Legend, so I was wondering if this measure could be converted to calculated column(s) so that I could get the same result and pull in as "Legend." I tried using this measure as a calculated column, but result comes out different. I appreciate any help!

[Greg_Deckler]

@Userpath77 It's not likely that you could convert that to a column successfully since it seems dependent upon the filter context of the visual. One method might be to use the disconnected table trick:

In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...