Forum Discussion
Infinity values in calculated column without any division with zero - How to correct?
Hi Anonymous ,
That’s weird. Even with the sample data from you, I can’t repro this issue as well.
Portfolio value Table
Stocks Table
No relationship between these two tables
Calculations:
1 Portfolio value (Measure)
Portfolio value = CALCULATE(SUM('Portfolio value'[Value]),FILTER('Portfolio value', 'Portfolio value'[Holding type] <> "Liabilities"))2 Stock Yield (Calculated column)
Stock Yield = DIVIDE(Stocks[Market Value],[Portfolio value])*Stocks[Gross indicative div yield]Drag Stock Yield to clustered column chart, it looks like this.
Could you please drag and drop "Portfolio value" Measure to a table visual to check whether it has correctly calculated the result? In addition, please check if this issue is caused by improper data type or filters in the report. Thanks in advance!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!
Best Regards,
Community Support Team _ Caiyun
the problem seems to be with the portfolio value calculated field because if I replace portfolio value with some other calculated field, it works. However, I have thoroughly check portfolio value for any errors or 0s and there's none.
Is the Portfolio value a calculated measure or a calculated column?
it is a measure
Try creating a calculated column with just this measure.
Like
Test Portfolio Value = [Portfolio Value]
and see what results you are getting at each row