Forum Discussion
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 ...
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.
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.