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.

simormate's avatar
simormate
Frequent Visitor
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.