Measure working in Desktop but not in Power BI online

[Anonymous]

Hi, i have a measure that seems to be working as i would expect and fine in Power BI desktop but once i publish the measure to an app i get an error;

The query referenced column ******** which depends on another column, relationship or measure that is not in a valid state.

The measure i am trying to run is the following;

inT = IF(
        AND(LOOKUPVALUE('OID OTA'[Out ID], 'OID OTA' [Out ID],'DB'[Out ID])>1,'DB'[ID]>0),
    FALSE(),
    IF(
        OR(
            NOT(IFERROR(LOOKUPVALUE('E'[Concatenate],E[Concatenate],DB'[Concatenate])='DB'[Concatenate],False)),
            'DB[Level Product]<'DB'[Level]), 
        FALSE(),
        TRUE()))

I am not sure what is driving it to error but have seen a copy of our posts saying it may be down to the measure? 

[Anonymous]

Hi  @Anonymous  ,

In services, reset the filter to see if measure works normally

Best Regards,

Liu Yang

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

[Greg_Deckler]

@Anonymous - So is there a specific column mentioned or does the error really say "column ********". Are you able to share the PBIX file?

[Anonymous]

@Greg_Deckler no its doesnt say ****** it just has the table name. Sadly i can't share the report for privacy reasons. But i am just trying to understand if this is down to how the calculated column is working or something that is out of my control