Find Ratio As i range date

[Anonymous]

Hello I have 2 tables openers and closers:

As you can see below:

I am using the date of the closers table for the visual. if you see the card is adding the closer in the gauge ( in 27, middle was 80.37) and 28 was 84.35 so when i selected 27 and 28, it gave me the sum which is164.72. but when you see the taregt which is for openers, you see that the data isnt adding up. i cant create a new relationship between openers and closers with date since it tells me to delete the other relationship. but its important any help?

NOTE: the count of openers for all dates is 1,698,501 so it is clearly not counting the numbers of deals per the day i selected

@tamerj1 @amitchandak @SpartaBI 

[daXtreme]

Hi @Anonymous 

Using many-to-many relationships in a model is not to be taken lightly. It's tricky and you have to have a VERY GOOD understanding of all the pitfalls and how to avoid them. I'd kindly suggest you change the model to use 2 fact tables and one date dimension connected to both. You could name it, say, Closure Dates. If you do that, it'll be much easier to get this right. I guarantee.

Before even thinking about using many-to-many, please read THIS.