Forum Discussion
Trouble Calculating Measures Using Multiple Tables
I am trying to create a measure that will calculate the target number of accounts and leads to show in several card visualizations in order to maintain our marketing/sales pipeline, but I'm running i...
How are you determining whether it "works" or not? To an outsider, those are just numbers in the screenshot and it isn't immediately clear whether they are correct or wildly wrong.
We've validated the data through our CRM outside of PBI. I can pull a list of accounts with a score of 1-40, list of leads 1-40, etc. Based on that number, I feel comfortable saying that the calculations in the card visualizations.
My point wasn't that I don't believe you about it being wrong but rather that without knowing what kind of values you expect to see and how they differ from what you are seeing (and why they should be different), it's difficult to make any useful suggestions.