Forum Discussion
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...
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] ) )
HI rajul_rstgi
Except function in DAX Returns the rows of one table which do not appear in another table.
Try this MEASURE
ID's in B missing in C =
COUNTROWS (
EXCEPT (
FILTER ( ALL ( TableName[SystemB_ID] ), TableName[SystemB_ID] <> BLANK () ),
ALL ( TableName[SystemC_ID] )
)
)
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] )
)
Zubair_Muhammad and stretcharm Thanks a lot for your help with thisl
