I'm looking to calculate the percent based on a filtered value in Table One and the same filtered value in table 2.
Table One contains all users and the number of times they logged into an application via their desktop and via a mobile device. This leads to a single person potentially having multiple logins via each platform each day. We are only interested in if they logged in via mobile or desktop at any given point in a single week.
Table two contains the number of users broken down by their physical location.
What I'm looking to do is based on the slicer that is set on the report for the location is calculate the percentage of users who logged in via their desktop and mobile each week.
I can't figure out the best way to calculate this in PowerBI.
2. Site XYZ. Did you mean column [PhysicalLocation] = "XYZ"?
3. Is the relationship between the two table column [AssignedLocation] = column [PhysicalLocation]?
4. Is Total User = the value in column [Employee Count].
Since you have already shared the sample data. Why don't you explain your logic based on this sample data? Also, please kindly share us the sample data which we can copy and paste directly.
By the way, I have made a sample based on my assumption. First I created a relationship between the two tables on column [AssignedLocation] and column [PhysicalLocation]. Then created measures to calculate the percentage.