Forum Discussion

abhishekpati86's avatar
abhishekpati86
Helper III
9 years ago
Solved

DAX function for converting a number into a string?

Hi All,

 

I have a below measure : -

 

Risk = IF(AVERAGE(Barcelona_Combined_Data[TotalScore]) >=4 ,"HIGH",IF(AVERAGE(Barcelona_Combined_Data[TotalScore]) >=2,"MEDIUM","LOW"))

 

Can anyone help me to convert it into a column so that I can use it in graphs to create visualization.

 

Thanks,

AB

Need Help
Show and Tell
  • CahabaData's avatar
    CahabaData
    9 years ago

    It is not clear as to your data model.  In your IF statement you are also attempting to derive an Average calculation.  I would suggest you first set up a column/measure that contains the average value.  This does not have to display.  Then set up your measure/column with the IF statement for the text value.

     

     

1 Reply

  • CahabaData's avatar
    CahabaData
    Memorable Member
    9 years ago

    It is not clear as to your data model.  In your IF statement you are also attempting to derive an Average calculation.  I would suggest you first set up a column/measure that contains the average value.  This does not have to display.  Then set up your measure/column with the IF statement for the text value.