I'm trying to determine the best way to create a measure that will provide the following info:
Sum of EecAssignedCount by EEClocation that will take into considertation the slicer selection(s) of Jobclas from Master Login. Below is some sample data:
IE: Total SUM for AUS is 132 if all selections are selected for Job Clas which is the default. If the user selects only Paralegal, the measure would show 19. If they selected Paralegal and Shareholder it would show 39, etc.
Site_Locationinfo - Bridge
Here are is the screenshot of the relationships I have setup with the bridge table to try to accomplish this:
This paticular report has to be viewable both in our PBI-RS and Service enviroments so I'm designing it in PBI-RS which doesn't yet support many to many relationships.
Thank you in advance for any insight you are able to provide.