Using a function returns blank when using another function value

Hi stuartcorns 

Please change you model as soon as possible to a correct one, meaning a star schema. Your current model is not following Best Practices and therefore you'll very soon have multiple problems (you already have). Please, before you start doing any serious work with PBI, read this: Understand star schema and the importance for Power BI … (bing.com)

Also, you should never filter by a full table, especially by a fact table as this puts a lot of stress on the engine and DAX becomes slow to the point where you're going to get timeouts. The golden rule of DAX is: Never filter a table when you can filter a column.