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

parry2kWeighted_Avg is being calculated in SQl and thats a float field. its not accepting NA since its a varchar

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)