Forum Discussion

simormate's avatar
simormate
Frequent Visitor
5 years ago
Solved

Duplicate value error message in Power BI, when the same code works in DAX Studio

I use the following code for a calculated table in Power BI: CALCULATETABLE( Contracts, PricePlans[Range] = TRUE(), Partners[Parent Company Name] = BLANK() ) The table cannot be created, and I ...
Need Help
  • simormate's avatar
    simormate
    5 years ago

    Ok, I found a solution, I just needed to ask the question here 🙂

    I deleted the table and recreated it again, and it worked. Maybe it had to do with a calculated column I added to this table. After adding the calculated column, I modified the model somewhat, which resulted in the error message.

     

    Anyway, I would still love to hear some ideas about how could I have diagnosed the problem.

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

I got the idea of deleting and recreating the table again. However, it is very strange. In my case I get the same message but I was creating a table with the DAX UNION function and according to the documentation although there are duplicates in the two sets with the same columns, it still failed me but it should work. I backed up the DAX code, deleted the table then recreated it with the same code and that's it.