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
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
tried this as well. It treats the portfolio value column the same way as the measure. Basically, no difference in output