Forum Discussion

rajul_rstgi's avatar
rajul_rstgi
Frequent Visitor
8 years ago
Solved

Counting distinct values

  I am working with a dataset which is a output of full joins across 3-4 systems. I am trying to get distinct count of the id's missing in each system   System A  System B  System C  AAA        A...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    rajul_rstgi

     

    Above will return the Count of Missing IDs.

    If you want a list of Missing IDs... Goto Modelling Tab and select NEW TABLE

     

    List of ID's in B missing in C =
EXCEPT (
    FILTER ( ALL ( TableName[SystemB_ID] ), TableName[SystemB_ID] <> BLANK () ),
    ALL ( TableName[SystemC_ID] )
)

     

rajul_rstgi's avatar
rajul_rstgi
Frequent Visitor
8 years ago

Thanks. I already have the data merged in single row. I am trying to find a good way to create measure  to do a distinct count on each of these columns missing values, based on the distinct values in other 2 columns.

 

Hope this helps clarify the problem statement.