topic Re: Custom measure is not showing when Im trying to use it in another measure. in DAX Commands and Tips

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

New_Folder — Mon, 13 Nov 2023 21:11:43 GMT

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.

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

Jihwan_Kim — Tue, 14 Nov 2023 04:10:52 GMT

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] )

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

New_Folder — Tue, 14 Nov 2023 21:16:29 GMT

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?

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

Jihwan_Kim — Wed, 15 Nov 2023 03:33:53 GMT

Hi,

Please share your sample pbix file's link.

Thank you.