Need help creating a new Measure to filter on a Table
I don't really know how I should lable my question, but I have the following DAX Measure to give me Current Employees for any Point In Time basically. This one works great, but now I need to filter to also include people that are considered Sr. Management which consists of Executive Team, Sr Vice President, Vice President.
I can get one Table for All Sr Mgmt (includes Males& Females), Female Sr Mgmt, and where I'm struggling is having one Table to include this count vs having multiple tables. I'm not sure how I need to build my Measure to capture this.