Forum Discussion
Solved
Count Distinct combining two tables
Hi all, Hope you can help me. Been struggling with this for some time now. I have two tables: one with employee data and another with their projectassignments. I just need a simple grid with their n...
MarcoDekker Try:
Measure = COUNTROWS(DISTINCT(SELECTCOLUMNS('Table 2',"__name",[assignedprojectname]))) + 0
hi Greg_Deckler, Thanks a lot. it works indeed! I have one more question.
In table 1 i have more columns. When i create the report and add more attributes from this table, i get some kind of cartesian product. Why is this?
b.t.w. i create visualisations with direct query on a tabular model.
MarcoDekker I'm not sure. Can you share a screen shot or more information?