Disabling lineage

[Anonymous]

Hi

I'm creating, in DAX, a calculated table that UNION two ones

- a "normal" table

- and a SUMMARIZED one that takes data from another one

It works but when I try to drag relationships between other dimensions of my schema, PowerBI warns me of circular dependencies. As this table is not connected to anything else, I'm pretty sure that this is due to the fact that the SUMMARIZE takes data from a table and the lineage of the columns is preserved.

So I know that TREATAS can be used to "build" lineages, but is there any way to "disable" lineage when writing a summarize?

Thanks

[Mariusz]

Hi @Anonymous 

This article is probably worth a read. https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Mariusz, that was very helpful, thanks. In fact, my model is fairly complex with at least three calculated tables, and probably some implicit ALLs