Forum Discussion
Interaction Between FILTER() and ALL()
First let me describe the situation: I have a table with "Order Date" , "Supply Date" and "Sum" columns, and a date table. I created a relationship between "Supply Date" and the date table. and i n...
Hi tomerfaith,
I found out the issue. In my sample, the relationship between Calendar and ORD is one to one. However in yours, it is many to one.
To resolve your issue, you just need to change the relationship to one to one.
And if you want to know why. Honestly I have no idea. It seems like there exists some limitations which we don't know in many to one relationship.
Thanks,
Xi Jin.
First thank for helping.
I have 2 problems:
1)Even when I set the relatonship to one to one I still get this:
while the 60 total is correct, the table does not show all the orders which were open during 2017.
2) In the real report the ORD table is big and the relationship IS many to one (power bi won't let me change this),