Forum Discussion
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 ...
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
Super User
Ok, so add a measure for average calculation , if you already have just change it as below:
Avg = var a = AVERAGE(Table3[Rating]) return if(ISBLANK(a) || a = 0, "NA", a)
