Duplicated rows after creating calculated table

[nat365]

HI,

Recently I've added calculated table in my Power BI model, which resulted in duplicated rows in table visual when there is no match between imported table and calculated table.  

Dax Code:

CalcTabl= SUMMARIZE(

    CALCULATETABLE(Table1, Table1[Status]="Y"),

    Table1[Product],

    "Material Source", CONCATENATEX(VALUES('Table2'[Source]),'Table2'[Source], ",

    "),

    "Number of Materials", DISTINCTCOUNT(Table1[Material]),

    "Material", CONCATENATEX(VALUES(Table1[Material]),Table1[Material], ",

    "),

    "Material Description", CONCATENATEX(VALUES('Table3'[Description]),'Table3'[Description], ",

    "))

Do you know if there is a way to put filter in code that defines columns instead filtering source table?

Or is there another way to eliminate duplicated rows?

Thank you for you help in advance!

[Anonymous]

Hi @nat365 ,

As checked the formula of calculated table, it involves 3 tables: Table1, Table2 and Table3. Is there any relationship among these 3 tables? If yes, please provide the relationship info(cardinality, direction etc.). Could you please provide some raw data in your tables (exclude sensitive data) with Text format and your expected result with some example and screenshot? It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[lbendlin]

I would have said you should slap a DISTINCT()  around your SUMMARIZE ().  But that sounds odd, as SUMMARIZE already does the deduplication for you.  Can you show an example of the alleged duplicates?