DAX function for converting a number into a string?

[abhishekpati86]

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

[CahabaData · Accepted solution]

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.