Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Summarize returns "duplicates"

What I'm trying to do: 1. Use DAX Summarize to group a table by two text columns like this: D_BatchID = SUMMARIZE(F_StockEvent, F_StockEvent[ItemID], F_StockEvent[BatchID]) 2. Create a new column t...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hey v-piga-msft,

     

    Thanks for the help. I played around with the query editor and managed to fix the problem using Table.ReplaceValue, replacing null values with empty values (Table.ReplaceValue(F_StockEvent_dummy_table,null,"",Replacer.ReplaceValue,{"BatchID"})). There was no space character in the BatchID, it was just empty while other rows had null.

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi Anonymous,

 

By my tests, it may caused by your data source.

 

When I copy your table to Excel and get data with Excel, create the calculated table with SUMMARIZE. It show like below.

 

 

If I confirm each blank value in BatchID is null. It will show like below.

 

 

It seems that you may have a space in BatchID, so you will get the issue.

 

Best Regards,

Cherry

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hey v-piga-msft,

 

Thanks for the help. I played around with the query editor and managed to fix the problem using Table.ReplaceValue, replacing null values with empty values (Table.ReplaceValue(F_StockEvent_dummy_table,null,"",Replacer.ReplaceValue,{"BatchID"})). There was no space character in the BatchID, it was just empty while other rows had null.