cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Memorable Member
Memorable Member

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

1 REPLY 1
Highlighted
Memorable Member
Memorable Member

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors