I have fact table which is about shipments. A shipment (FACT) contains a certain amount of containers. A ship (Dimension) contains a max amount of container (MaxTEU in my example). I want to calculate the LoadFactor which is nothing more then "ContainerAmount / MaxTEU". For example a shipment from A to B has 100 container. The ship could have a maximum of 1000 containers. The load factor would be 100/1000 = 0.1
The problem i have is that this somehow results in an infinite value. ContainerAmounr nor MaxTEU is zero so it should be a viable division.
I provided screen shots so you can see the relations i have. The MaxTEU dimension 'Ship' is not a measure group. Maybe this would have something to do with it, but im clueless to be honest. Does anyone know what i am doing wrong?