Forum Discussion
Total Target doesn't get updates when Date Slicer changes, while Total Revenue does
Hello,
I have 4 tables; Date, Revenues, Comapnies, Targets, that are relationshionshiped as per the screenshot below:Model
Unfortunately, when I change the Date Slicer, the Targets Values doesn't change at all, rather shows the TOTAL Target amount for all dates. Also, if I try to create a relationship between the Revenues and the Targets table, I get a many to many relationship which doesn't work either.
Your help is so much appreciated.
You need a relationship between Date and Targets.
Date <-> Date.
Br,
J
3 Replies
You need a relationship between Date and Targets.
Date <-> Date.
Br,
JGenerally having more than 1 facts table complicates things a little once your datamodel gets bigger. But there should really be no issue for you here.
If you like you can always append your targets table into your revenues table and use a column to differenciate:
But no, the square model shouldnt be an issue! 🙂