I have the attached 3 tables and modeled as shown.
Snapshot table (1)
Exceptions Table (2)
Employee Table (3)
I need to show the emloyee information for where they have an exception (Exception Table), how do i create a link between the Exceptions table and the Employee Table - this would be a many to many relationship.
I would like to have a visual table to show all the employee information for each Exception type and snapshot key.
Any ideas? Can I use CrossFilter and if so, how would that work?
I had tried this but it didnt give me the ability to view the employee table attributes..
Measure = CALCULATE(COUNT(Exceptions [Exception Type], CROSSFILTER(Exceptions [Snapshot Key],Snapshot [Snapshot Key],Both),
CROSSFILTER(Employee [Snapshot Key],Snapshot [Snapshot Key],Both))
|Snapshot Key||Month End||Version||Snapshot Date|
|Exception ID||Exception Type||Exception Employee||Snapshot Key|
|Employee Number||Division||Department||Snapshot Key|
Solved! Go to Solution.
Example as follows - the snapshot Key (will be represented by a date picker as a filter) - but for the exceptions noted, i want to see all employee details - in this example i have reduced the size of the employee table but as is a lot wider in reality.
The join between the Exceptons and Employee table is the issue..
Any help would be appreciated.
Check out the News & Announcements to learn more.
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!