Second Row of Matrix Table Showing All Results from Column

[kenyaherring93]

Hi!

I am having trouble adding a second row to my matrix table. The second row consists of username in which a user looks at the training course and expands the row to see all of the users who have completed and not completed the training.

The issue is.... when I expand ANY training course name I am shown a list of ALL of the users in my table and not just the applicable user related to the training course. I have three tables - One called Training Metrics which consists of all course names, and users.

I have two additional table that are just distinct columns of my course and completition status I created to display 0 in complete/non completed count totals. Any guidance is appreciated!

Screenshots attached for reference.

[HarishKM]

@kenyaherring93  Hey,
I will refer below data.

• Fix the model first: build a star schema. DimCourse, DimStatus (Completed/Not), and ideally DimUser should each have a 1-to-many, single‑direction relationship to FactTrainingMetrics.
• Use the right fields on rows: Course from DimCourse as level 1; Username from DimUser (or from Fact if no user dim) as level 2. Do NOT use a disconnected “distinct users” table on the matrix rows.
• Turn off “Show items with no data” for Username (field well > … > Show items with no data = Off). Keep it only for Course/Status if you need zeros; otherwise it cross-joins and shows all users.
• Ensure measures respect context: avoid ALL()/REMOVEFILTERS on Course/User. Optionally hide empty user rows with:

IF(CALCULATE(COUNTROWS(FactTrainingMetrics))=0, BLANK(), [YourMeasure]).

• To show zeros for Course × Status totals but not list phantom users: use a DimCourseStatus combo table for totals and COALESCE([Count],0), keep “Show items with no data” off for the Username level (or split into a totals matrix and a drill-through/detail table).

Thanks

Haish K 

If I resolve your issue. Kindly give kudos to this post and accept it as a solution so other can refer this.

[Ashish_Mathur · Accepted solution]

Hi,

Please share the download link of the PBI file.

[v-aatheeque]

Hi @kenyaherring93 

Following up to confirm if the earlier responses addressed your query. If not, please share the sample data and we’ll assist further.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community

[v-aatheeque]

Hi @kenyaherring93 

Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.

[nielsvdc]

Hi @kenyaherring93, you might want to check first if you used the correct columns in each relationship. That might be the cause for the visual to show all users and show them all with a 0 value. If the correct columns are related, please check the values in the dimension tables. These might not be the same values as in the related columns in the metrics table.

Hope this helps. If so, please give kudos 👍 and mark as Accepted Solution ✔️ to help others.