Forum Discussion
Slicer showing duplicates
Hello All, I have a fact table 'Table1' in which I have buyer_name column that has names of buyers (all my tables are in direct query). This table has duplicate values of buyers. So when I use th...
So, I just found that power bi is duplicating one of the buyer names when i create a calculated table table 2 using summarize dax function. I have tried groupby, value, distinct, but still it is duplicatng one of the buyer name. I dont know why.
but when I create another table Table 3 and use group by with Table 2. Then it gives me the right result.
However, when i export the duplicated Table 2 to excel, i cannot see that duplicate buyer name. It comes only one time.
I dont know whats happening here.