Static Table

Anonymous

Not applicable

2 years ago

Sample Data:

Course Data:

Name	Course Name	Employee ID	Score	Points	Attempts
Jim Bob	101 Intro to Learning	80	10	2
James Joe	102 Course 2	101223	70	10	1
John Doe	103 Can't Learn	101245	100	10	2
Tim Leavy	101 Intro to Learning	101885	80	10	1
Kyle Busch	102 Course 2	101695	95	50	5
Jim Bob	103 Can't Learn	101223	101223	100	1

Employee Data:

Name	Employee ID	Employee Email	Employee MGR	MGR Email
Jim Bob	101223	[email protected]	Salem Jones	[email protected]
James Joe	101234	[email protected]	Timmy Turner	[email protected]
John Doe	101245	[email protected]	Sandy Cheeks	[email protected]
Tim Leavy	101885	[email protected]	Oliver Smith	[email protected]
Kyle Busch	101695	[email protected]	Lenore Ryan	[email protected]
Jim Bob	101223	[email protected]	Sam Adams	[email protected]

I have joined both of these tables together with "Employee ID" as the main key. Right now the only courses showing are the ones that were completed by employees:
Ex: If Sussie only did 10/31 courses then those would show up.

I need all 31 courses to show regardless of completion. I have created a new table with all course names and employee ID. Which consist of a cross join. DAX: StaticTable = CROSSJOIN(VALUES('Course Data'[employee id]), VALUES('Course Data'[Course Name])) But I cannot get numbers to be specific like pictured below and instead it looks like the above image:

Forum Discussion

Related content

% with static denominator

Privacy Levels and Static Enter data tables

Convert query to static table

Static table Vs dinamic table

Static Outbound IP for Notebook