Custom measure is not showing when Im trying to use it in another measure.

[New_Folder]

I finally learned how make new measures. I made the 'Audit Finding %' measure a column. Now I want to make a line and clustered chart showing them in a graph with the AVG as the lines and values as bars. But I couldnt make it to wrk. I cannot use that same measure to make an AVG measure. Dragging the Audit Finding % in the Y-Line field does not allow me to change it to an AVG.

[Jihwan_Kim]

HI,

I am not sure how your datamodel looks like, but please try something like below if it suits your requirement.

average line chart measure: =
AVERAGEX ( ALL ( tablename[Team Member] ), [Audit Finding % measure] )

[New_Folder]

Its still not showing. The 'Audit Finding % measure' is not an actual column but is just a measure. Maybe that's why.

Is there a workaround?

[Jihwan_Kim]

Hi,

Please share your sample pbix file's link.

Thank you.