Forum Discussion
Linking 2 Tables
Well, first thing to do is to check if this is the problem. Create two measures and display them in card visuals:
Measure 7 = COUNT('Table10'[Text]) Measure 8 = DISTINCTCOUNT('Table10'[Text])If you get different values, you have an issue.
Then, typically what you do is to go into Power Query and do a Trim and Clean before your remove duplicates. It is often handy to sort the column in the model and visually inspect.
You can figure out what values are duplicated by doing this:
Table = SUMMARIZE(Table10,Table10[Text],"Count",COUNTROWS(Table10))
Generally this is a matter of what M considers a duplicate and what DAX considers a duplicate. Often there are trailing spaces, capitalization issues, etc. that M doesn't consider duplicates but DAX does.
Greg_Deckler Is there any way to check for this to see where the discrepanices may be?
Well, first thing to do is to check if this is the problem. Create two measures and display them in card visuals:
Measure 7 = COUNT('Table10'[Text]) Measure 8 = DISTINCTCOUNT('Table10'[Text])If you get different values, you have an issue.
Then, typically what you do is to go into Power Query and do a Trim and Clean before your remove duplicates. It is often handy to sort the column in the model and visually inspect.
You can figure out what values are duplicated by doing this:
Table = SUMMARIZE(Table10,Table10[Text],"Count",COUNTROWS(Table10))
Greg_Deckler Worked perfectly! Setting up the cards showed a count of 29 and distinct count of 30. The culprit was a null value in the count of 30. Once I removed that null value in the editor, all was good. Thanks again!