Forum Discussion
Advocate IRow Identifier within Power BI for Desktop (Circular dependencies with the DAX CALCULATE function)
Memorable MemberThis is a working in Tabular and Visual Studio SSDT..also in PowerPivot advanced table properties..not yet implemented in PBI Desktop..You can try the latest
For example, using ALLEXCEPT to remove the calculated columns from the set of columns that become part of the dependency list is a viable option, but it makes all formulas more complicated. On the other hand, using ALLEXCEPT might be useful for very big tables, where the addition of a row identifier would cause memory footprint to grow too much.
The second calculated column will be like = CALCULATE ( your measure ( and filters ) ; ALLEXCEPT ( TableName; TableName[FirstCalculatedColumn])
Never tried it but probably will work ( since Alberto says it will )
Hi Konstantinos,
Your suggestion worked, but you actually have to apply the ALLEXCEPT filter to all of the calculated columns, not just the 2nd column. Once I did it to both of mine, the error went away. I presume if I do a 3rd calculated column, I'll have to update the first two as well. Cumbersome, but at least it works. Thanks for your suggestion!
Trey Cook