DAX Help

[pmadam]

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

[ValtteriN · Accepted solution]

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/

[BeaBF]

@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