Forum Discussion

MarcoDekker's avatar
MarcoDekker
Helper I
3 years ago
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...
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    MarcoDekker Try: 

    Measure = COUNTROWS(DISTINCT(SELECTCOLUMNS('Table 2',"__name",[assignedprojectname]))) + 0
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

MarcoDekker I'm not sure. Can you share a screen shot or more information?

MarcoDekker's avatar
MarcoDekker
Helper I
3 years ago

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. 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    MarcoDekker Try: 

    Measure = COUNTROWS(DISTINCT(SELECTCOLUMNS('Table 2',"__name",[assignedprojectname]))) + 0