Forum Discussion
Help with DAX
Super UserSo you are trying to catch the people who put bogus data in the leads object? Usually a lead predates the opportunity creation (let alone the closure).
Please explain the rationale for the bidirectional links. Aren't Accounts and Customers the same thing?
What do you consider dimensions, and what do you consider facts?
Have you tried to create a snowflake schema?
Hi lbendlin ,
Accounts and customers are slightly different. Imagine Accounts as supplier and customers is actual customers and our business is a re seller.
Spot on with leads and opportunities. We only want to count total customers and total sales amount from customer entity once an opportunity is closed and only those where the date customer joined is greater than opportunity closed date.
Rationale behing the bidirectional link is so it will filter out those accounts based on the lead selection.
We havent tried the snowflake schema yet.
Regards