Forum Discussion

pmadam's avatar
pmadam
Helper II
3 years ago
Solved

DAX Help

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 d...
  • ValtteriN's avatar
    ValtteriN
    3 years ago

    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/

ValtteriN's avatar
ValtteriN
Community Champion
3 years ago

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/