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)

     

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. 

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