Forum Discussion

v-nankh's avatar
v-nankh
Frequent Visitor
8 years ago
Solved

Matrix - How to add a string value in a number column

I am creating a PowerBI Report with a number column which basically has Weighted Average and that I have calculated in SQL. The weighted average is calculated based on the rating and weight for each ...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    You still have add new measure and change the formula like this, I was not aware if average is pre-calculated.

     

    Add following measure and use it in your report.

     

    My Average = 
var myAvg = Average(Table3[Weighted_Average])
return if(ISBLANK(myAvg), "NA", myAvg)

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

You still have add new measure and change the formula like this, I was not aware if average is pre-calculated.

 

Add following measure and use it in your report.

 

My Average = 
var myAvg = Average(Table3[Weighted_Average])
return if(ISBLANK(myAvg), "NA", myAvg)

 

v-nankh's avatar
v-nankh
Frequent Visitor
8 years ago

parry2kThank you so much :smileyhappy: 

It's working!

 

I have another question. I am trying to apply conditional formatting. If the average is below 3 then it should be colored as red , if the average is above is 3 it should be green and if its NA then it should be grey. I was able to apply conditional formatting for below and above number 3 but not for NA. 

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    8 years ago

    Glad to hear it is working, not sure if color formatting can be done as you described.

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      8 years ago

      Sorry replied too quickly, i think what you can do is change values background color to grey and then conditional formatting will take care of color where applicable and NA will be grey. (I guessed it), try it.

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi v-nankh,

    If you have resolved your issue, please mark the right reply as answer. More people will find the solution easily.

    Best Regards,
    Angelia