Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Experts, Have a list that shows partners enrolled in courses, how to make a report that shows missed courses by each partner.
Solved! Go to Solution.
@koorosh , Create new table like
New table =except(crossjoin(all(Table[partner]),all(Table[Course Name])), selectcolumns(Table,"partner", Table[partner], "Course Name",Table[Course Name]))
https://docs.microsoft.com/en-us/dax/except-function-dax
cross join expect 2 inputs ,,,, you are including both columns in ALL statement... separate both columns
CrossJoin( all(Sheet1[Partner]), all(Sheet1[Course Name]))
Proud to be a Super User!
HI @koorosh ,
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
1- you need to separate Course from Orignal table, i.e. a table that contains all courses. From this table you can create course table like this.
Course = SUMMARIZE(Partner,Partner[Course])
2- Then join this table with your main table.
3- Create a matrix visual
4- Put Partner from partner table in Rows
5- Put Course from course table(new summarized table) in columns
6- create a measure for missed count
Missed Course = IF(COUNT(Partner[Course])>0,BLANK(),1)
7- Drop this measure in Values and see the results
Proud to be a Super User!
@koorosh , Create new table like
New table =except(crossjoin(all(Table[partner]),all(Table[Course Name])), selectcolumns(Table,"partner", Table[partner], "Course Name",Table[Course Name]))
https://docs.microsoft.com/en-us/dax/except-function-dax
Why get error Amit?
Hi @koorosh ,
You need to add a ) after Sheet1[CourseName]
Create a Table
T2 = except(crossjoin(all('Table'[User]),all('Table'[CourseName])),selectcolumns('Table',"partner", 'Table'[User], "Course Name",'Table'[CourseName]))
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
cross join expect 2 inputs ,,,, you are including both columns in ALL statement... separate both columns
CrossJoin( all(Sheet1[Partner]), all(Sheet1[Course Name]))
Proud to be a Super User!
The result is wrong,
In the new table "arad" should be shown with "B" and "C" course.
Hi @koorosh ,
Your Sheet1 Table in the Visualization Pane should have values from New Table.
Here in the screenshot the values are selectd from the sheet1 table.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Thanks to all gentlemen, Amit, Farhan, Harsh.
Hi, Again Experts, why partner name slicer does not work for both tables?
In the main table (sheet1) arad enrolled in "A" and "D" course. In the new table, we are looking for missed courses for arad!
HI @koorosh ,
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |