Forum Discussion
Circular dependency issue - worked previously
Hi, SDittmannFleet
Can you achieve what you need by adding the required columns to the visual object and creating a Measure, thus avoiding the need to create a Total Expense LTD, and if you don't have a clue, you can share the pbix file with no sensitive data to help with the testing.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Can you please provide an example for a measure (you can use the parameters/values from the calculated table)? Basically, what I need is a measure that returns LTD expense (the sum of Invoice Segment[Grand Total Final Before Tax]) for each asset ID, and if there is no entry for an asset ID in the invoice segment table, it should return either 0 or nothing, no preference. Asset and Invoice Segment are connected in a 1-* relationship.
I have tried a few approaches, but no matter what I do, I get a ton of duplicates in the table, which is obviously not what I want, or on top of it some really weird results for the sum.