Help with Incorporating a Field into Formula

[mbmcdonald2]

Hi All - 

I'm having trouble with a particular formula in a table I'm putting together where when I apply a particular filter all of the values become the same thing. My guess is I haven't incorporated my filter component into this correctly but I'm not totally sure of the solution. 

Please see a copy of my work here: https://drive.google.com/file/d/1BF1stDYaDUDH-88s1rN4uRE6nzUd1Sz9/view?usp=sharing 

Any assistance would be greatly appreciated!

[speedramps]

Thank you @mbmcdonald2  for the example data.

You description is very vague but I can clearly see that your data does not have a Start Schema.

The data has 2 many to many releationships and a circular reference.

If we attempt to fix your current problem then you likely to encounter other problems elsewhere.

Please learn how to use Power Query to reshape your data into a Start Schema here:-

Understand star schema and the importance for Power BI 

Also watch you tube videos.

Sorry, if this answer seems unhelpful but I have correctly identified the problem and the solution.

Sadly I dont know your bussiess or field names meaning and cant offer any more help with such a vague problem description.

Please accept the solution and click thumbs up. Thank you

[speedramps]

You need to grant access to that file 😀

[mbmcdonald2]

hi @speedramps I believe I granted you access now. Thanks!