cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JJenkins2005 Frequent Visitor
Frequent Visitor

Help Needed - Dax Measure

Hello,

 

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. 

 

MasterLogins.pngMaster_LoginsSiteLocation.jpgSite_Locationinfo

 

Site_Locationinfo - Bridge

 

SiteLocBridge.jpg

 

Here are is the screenshot of the relationships I  have setup with the bridge table to try to accomplish this:

 

 

Relationships.jpg

 

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. 

 

6 REPLIES 6
v-danhe-msft Super Contributor
Super Contributor

Re: Help Needed - Dax Measure

Hi @JJenkins2005 ,

Due to it is hard to reproduce your problem, could you please offer your pbix file to have a test if possible?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JJenkins2005 Frequent Visitor
Frequent Visitor

Re: Help Needed - Dax Measure

Howdy...  There is too much confidential info in the file.   If I remove it, there wouldn't be enough material information available to assist.  Thank you for checking. 

Anonymous
Not applicable

Re: Help Needed - Dax Measure

If the data is linked you might be able to achieve the total you are looking for with slicers and page level filters. 

 

Ex. If you select AUS in a location slicer you could then filter to the job class and display the total in a card visual. 

 

I've done this with a scenario (I beleive is somewhat similar) where I wanted to display the total number of leads through filtering an account, then by the account owner. 

jtownsend21 Member
Member

Re: Help Needed - Dax Measure

It's really difficult for us to help with what you have given. Please see this post. 

 

How to get questions answered quickly.

JJenkins2005 Frequent Visitor
Frequent Visitor

Re: Help Needed - Dax Measure


Thank you... I was able to get the info that way, but our Directors didn't want to have C-Levels using page filters everytime they needed to change a site. 
@Anonymous wrote:

If the data is linked you might be able to achieve the total you are looking for with slicers and page level filters. 

 

Ex. If you select AUS in a location slicer you could then filter to the job class and display the total in a card visual. 

 

I've done this with a scenario (I beleive is somewhat similar) where I wanted to display the total number of leads through filtering an account, then by the account owner. 


 

Highlighted
Anonymous
Not applicable

Re: Help Needed - Dax Measure

I'm not sure how to create the dax measure, but couldn't you create multiple card visuals that only display this information through page level filters? 

 

Ex. Create a card for each of the job classes to display the total based on the location slicer filter? 

 

I beleive that would resolve the issue of having to utilize multiple slicers. 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 41 members 1,019 guests
Please welcome our newest community members: