Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
In the August Release we had several calculated columns structured as shown below where the calculated column is created on an imported table but it refrences fields in a direct query table.
OpenEscalations = calculate(
sum(ServiceCalls[Escalated]),
filter(ServiceCalls,
ServiceCalls[ID]=Devices[ID]
&& ServiceCalls[DateClosed] = blank()
)
)
In the August Release of Power BI Desktop this formula works properly. I can create a table where I list devices and the total number of escalations associated to each device next to it. After upgrading to September, the formula and visuals continue to function until any attempt to change it (even changing it back to it's former state) results in an error message "The expression referenced column [Column Name] which does not hold any data because it needs to be recalculated or refreshed." Note that the table/column name in the error message need not be included in the DAX formula. It's another similar formula on a completely unrelated table.
I have a file that uses 4 of these types of formulas and once any of them are edited, all of them stop functioning. Additionally, all measures using the direct query tables also stop functioning (all reporting the same error message referencing a table/column that doesn't necessarily have anything to do with the measure or calculated column in question).
Attempting to refresh the entire file doesn't appear to have any impact on the issue. The only way to get the file back to a workable state seems to be to delete all instances of calculated columns which reference direct query tables.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.