This is a little better, but the request is still in the realm of full-blown consulting support rather than forum support. Without relationships specified, this isn’t yet a data model. Also, it has no Date table, which is absolutely essential for time intelligence calculations, the category that all of your desired measures fall into. Also, please keep in mind that while you’ve been working with this large dataset extensively and understand the field names, the assocated business processes and other important aspects of this data, no one providing support on the forum will have this knowledge. That’s why it’s so important to be as specific as possible in your questions, provide mockups of the results you want to achieve and take an initial run at the answer yourself, so that we have a strawman to respond to that doesn’t require in-depth knowledge of your data and business.
That being said, I think the “Events in Progreass” DAX Patterns series developed by Enterprise DNA Expert @Greg will be extremely helpful to you in developing the desired measures.
Still a lot more work to be done on your end first, but once you get to that point if you’re having problems, give a shout.
Thanks.
- Brian