Using value from another linked table in a measure
Hi Guys. I'm stuck really bad in this one. I have 2 tables : 1. Facts table 2. Dimesnion table. Following image depicts the relationship established between the 2. The table at the top is the Facts table. "OI Owrking Days" is the dimension table.
I wish to create a multiline chart which will have the "FY" field in the legend well, Month field in Axis well and a measure in the Values well. The measure is supposed to calculate Per day amount so the formula for the same would be : SUM(Amount)/working days. I need to have the working days to be fetched from dimension table for each month that is plotted on the X-Axis. Following is what I have tried so far :