Deleting a measure value using a value from a related table

[Phantomiceman]

Hi i am new power bi and Dax . I have a measure  ('Actual Delegates')thats setup to calculate the total number of delegates on a course which appears to work fine but i cant seem to be able subtract a value that is in a related look up table to work out what the addtional people are on a course.The look up table is connected to the datatable via the course type column . The measure doesnt appear to pick up the look up table either hence why  havent be able to assign it to the minimu delegates column. Even when i manually type the table in the relationship isnt being picked up

The measure im curently using is :-

Additional Delegates = calculate([Actual Delegates] -related([Minimum Delegates]) ,FILTER('Resource Planning','Resource Planning'[Course Type]<> BLANK()))

[parry2k]

@Phantomiceman if [Minimum Delegates] is a measure then you don't need to use RELATED function.

[Phantomiceman · Accepted solution]

Hi Parry i ended up using a different approach where by i created a summarised table and then joined onto the table and did muy subtraction from there on.. Thanks none the less 😀

[v-chuncz-msft]

@Phantomiceman 

By the way, you may help accept solution. Your contribution is highly appreciated.