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 different visuals i need this Parameter in Avg, Median, min etc. Please help

 

 

Thanks,

Prathy

  • 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/

2 Replies

  • BeaBF's avatar
    BeaBF
    Super User
    3 years ago

    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

  • 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/