topic Re: DAX Help in DAX Commands and Tips

DAX Help

pmadam — Mon, 12 Sep 2022 04:54:22 GMT

Hi Team,

Im trying to get median of Field Paramater which contains Price values. Field Parameter is converting PRice values into text so Im not able to create median of it. How do i fix it? For different visuals i need this Parameter in Avg, Median, min etc. Please help

Thanks,

Prathy

Re: DAX Help

BeaBF — Mon, 12 Sep 2022 06:57:37 GMT

pmadam Hi! you have to change the formula of the Field Parameter, because the function "nameof" returns a string. So, what do you want to do in PmPrince? Do you have some sample data?

BBF

Re: DAX Help

ValtteriN — Mon, 12 Sep 2022 07:08:04 GMT

Hi pmadam ,

I assume you are trying to take median in this kind of scenario:

Data:

Parameter:

Unfortunately it isn't possible to my knowledge use the field parameter value in this way. If possible I would recommend modifying your data a bit. So try something like this:

Unpivot:

And now median:

You can use the attribute column as a slicer.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/