Forum Discussion
Goals without average
Hi! I'm pretty new to Power BI and have only scratched the surface of its capabilities. This is probably very simple for most of you, but it's making me crazy and I'm hoping your expertise can help m...
It can be a little complex, but much easier to break it down into smaller sections and go from there. Just have to put in some time and you'll get it :smileyhappy:
Anonymous , I've replicated all your suggestions except FactSALES. I'm trying to pull in the number of sales from a related table so that it gives me a count of sales by person like a pivot table would in Excel. Then I can duplicate your matrix. However, it is pulling in everyone on the list and I can't determine the best filter to use in order to limit the number of records pulled. I think it should be a date one, but am not certain. See below snippet. Any suggestions? Thanks again for all your help!