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?
Hi Greg_Deckler . Alas, not able to reproduce this behaviour in the test pibx. Will continue to try.
But i realised, i miss Jane in the output. Can we generate some kind of left outer join in Dax? Jane does not have projects assigned, yet she need to show up in the report.
MarcoDekker Try:
Measure = COUNTROWS(DISTINCT(SELECTCOLUMNS('Table 2',"__name",[assignedprojectname]))) + 0