Solved: DAX function for converting a number into a string...

abhishekpati86 · ‎10-03-2016

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 · ‎10-03-2016

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.

www.CahabaData.com

View solution in original post

CahabaData · ‎10-03-2016

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.

www.CahabaData.com