Forum Discussion
Convert Measure
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!
1 Reply
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/ba-p/279563
