Forum Discussion
Calculating customer review data
Hi, I am importing customer reviews into PowerBI. They are in a format with one row per review. I need to do some extra calculations to work out our ratings over a specific period. For exam...
Jenjen , I think you can simply do a new measure
Average(Table[Service Rating])
where Service Rating is a number. Avg should not consider blank
else try measure
calculate(Average(Table[Service Rating]), filter( Table, not(isblank(Table[Service Rating])) ) )