Column cannot be found or may not be used in this expression

[bryanshaw46]

I am having trouble with a measurement formula.

Avg Days to Resolve = DIVIDE( Sum(FactIncident[DaysToResolve]), Sum(FactIncident[IncOpen]))

The error is: Column 'IncOpen' in table 'FactIncident' cannot be found or may not be used in this expression.

The column DOES exist as a calculated column using:

IncOpen = CALCULATE( Sum ( FactIncident[NewQty] ), USERELATIONSHIP( FactIncident[FK_NewDate], TimeHour[YYYYMMDD_PK] ))

FactIncident[NewQty] is always 1.  I have to specify the relationship because it is inactive. 

So I went hunting on the Modeling tab:  IncOpen does NOT have a data type.   Maybe that is my problem???   How can I fix it?

[Anonymous]

I figure this must be closed now.

But I had this issue, that one of the new columns I created was referencing this column name. BUT I had changed that column name in the background.

[v-micsh-msft]

Hi bryanshaw46,

I suspect this should be caused by the userrelationship function.

"

If CALCULATE expressions are nested, and more than one CALCULATE expression contains a USERELATIONSHIP function, then the innermost USERELATIONSHIP is the one that prevails in case of a conflict or ambiguity.

"

As [Avg Days to Resolve] is a measure, and the FactIncident[IncOpen] is calculated column, USERELATIONSHIP function is somehow "nested".

UserRelationship reference.

Would you please share some data sample here for us to do a further investigation?

Or consider share the relationship View of your data, make sure all the items that involved in this issue are in the screenshot.

By the way, have you tried to change the IncOpen data type to whole number? Select it under the Fields pane, under modeling tab, it would be available to change the data type.

Regards

[bryanshaw46]

I appreciate any help someone can lend me.