Forum Discussion
Calculated column returning NaN and infinity
hi Anonymous
First, you should know that:
1. Calculation column/table not support dynamic changed based on filter or slicer, it is static.
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
Second, You could use DIVIDE Function in your formula as below:
https://docs.microsoft.com/en-us/dax/divide-function-dax
https://docs.microsoft.com/en-us/power-bi/guidance/dax-divide-function-operator
Column=DIVIDE('column1'[Hours_Actual],'column2'[hours_budget],0)and for measure you could use this formula
Measure=DIVIDE(SUM('column1'[Hours_Actual]),SUM('column2'[hours_budget]),0)Regards,
Lin
Have you looked at the IfError?
If the calculation shows an error then it will show whatever you want it to show, otherwise it will show you the result of the division.
https://docs.microsoft.com/en-us/dax/iferror-function-dax
PercentHoursRemaining = IFERROR ('column1'[Hours_Actual]) / ('column2'[hours_budget], 0)