I am struggling with this concept and am need of some support. I have two tables that have a one-many relationship, table 1 being one and table2 being many. I am attempting to filter down table2 with a specific column in table1 and perform a distinctcount on the rows in table2. Once complete, I want to change the context back to the next row in table1 and perform the same count for the new table2. This iteration needs to take place for table1 and once complete, I need to sum up all of the distinctcounts.
Does anyone know if Sam has worked through a similar example and if so, can you tell me which course it is? Once I get back to my computer, I will share a screenshot of my model and Dax formula I’m using.