Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Help with Incorporating a Field into Formula

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!

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

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

  • speedramps's avatar
    speedramps
    Super User
    1 year ago

    Thank you Anonymous  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