Forum Discussion

nat365's avatar
nat365
Frequent Visitor
2 years ago

Duplicated rows after creating calculated table

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!
Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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