Forum Discussion
Static Table
Hello,
I am building a "report card" type power bi dashboard. Currently I have two tables that consist of "course data" and "employee data" joined together based on the employee ID. I am having an issue witht the courses on the table visualization. When I add courses to the rows and score, attempts, and points to the values it only shows the course name that was completed and not all the courses whether or not it was completed or not. I need some assistance making a relationship between the two data tables I have and a static list that will show all the courses regardless of completion. If they haven't completed it then it should just be a 0.
Currently what I have and it has all the courses but the scores are not updating:
Hi Anonymous
Your problem has been solved in the following post:Solved: Power BI Dax questions - Microsoft Fabric Community
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Anonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.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:Anonymous Still not sure if this is what you are looking for but see attached PBIX below signature.
Hi Anonymous
Your problem has been solved in the following post:Solved: Power BI Dax questions - Microsoft Fabric Community
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
