topic Help with Incorporating a Field into Formula in DAX Commands and Tips

Help with Incorporating a Field into Formula

Anonymous — Fri, 10 Jan 2025 13:56:59 GMT

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!

Re: Help with Incorporating a Field into Formula

speedramps — Fri, 10 Jan 2025 15:56:16 GMT

You need to grant access to that file 😀

Re: Help with Incorporating a Field into Formula

Anonymous — Mon, 13 Jan 2025 18:54:50 GMT

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

Re: Help with Incorporating a Field into Formula

speedramps — Tue, 14 Jan 2025 10:36:37 GMT

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