Convert Measure

Userpath77 — Thu, 29 Jul 2021 17:13:35 GMT

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!

Re: Convert Measure

Greg_Deckler — Thu, 29 Jul 2021 17:56:44 GMT

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

topic Convert Measure in DAX Commands and Tips

Convert Measure

Re: Convert Measure