Calculating total with displayed values

Hi @ammu,

You generally get a NaN error when you Divide 0 by 0.

So in this case,

Try something like this.

Measure =
If [no of Res] = 0 || [NY Bed Occ] = 0 || MAX('Table' [CostCenter]) = BLANK() , 0 , DIVIDE(what you are dividing) )

You can also have a look these links.

https://www.spguides.com/power-bi-nan-error/
https://radacad.com/make-your-numeric-division-faultless-in-power-query

Regards,
Harsh Nathani