Forum Discussion
Solved
Dates table relationship not working properly
Hello all, Could you please help me solve this issue with which I've been losing my mind for hours? I have a 'Data table' with "Invoice date" with a relationship to 'Dates table' which I created th...
Nevermind. I finally figured it out. There was a 'Margin' measure inserted into the table
= 1 - SUM([Cost]) / SUM([Sales])
which messed it all up. Such a stupid mistake.
Thank you anyway.
hi Tomfiki
can you share the pbix?
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Nevermind. I finally figured it out. There was a 'Margin' measure inserted into the table
= 1 - SUM([Cost]) / SUM([Sales])
which messed it all up. Such a stupid mistake.
Thank you anyway.