The query referenced a relationship which depends on a column that is not in a valid state

[dlopesc04]

Full error:

"The query referenced a relationship between 'Fact_tb'[dimension] and 'Dimension_tb'[Dimension], which depends on a column that is not in a valid state."

I've created a calculated table based on two fact tables, pulling a distinct of a column (present in both) wich is the dimension I desire to have in a single table. Then used Union on both Distinct Columns and used Distinct again, to get a single usable result. DAX:

Dimension_tb = DISTINCT(

                              UNION(

                                  DISTINCT( Fact_tb[dimension]),

                                  DISTINCT(Fact_tb2[dimension])))

This works fine on Desktop. After publishing it works fine on the PBI Service. But after refreshing the Dataset it results in that error, and I've tried:

1. Checking Data types (Both text)
2. Checking for Case on both (Used Upper on PQ on both)
3. Checking sources. One is imported from a SQL DB, the other from a Dataflow (Which pulls from a SQL DB)

Everything indicated this should work, but it doesn't. I'm doing this in DAX because in PQ I have to load the fact tables multiple times and include them in the refresh (Tables are huge). With the calculated table I only refresh the fact tables once.

What else to do?

[dlopesc04]

@Sahir_Maharaj Hello!
It has unfortunatelly not worked.

[Sahir_Maharaj]

Hello @dlopesc04,

Can you please try this simplified DAX:

Dimension_tb = DISTINCT(
    UNION(
        SELECTCOLUMNS(Fact_tb, "dimension", Fact_tb[dimension]),
        SELECTCOLUMNS(Fact_tb2, "dimension", Fact_tb2[dimension])
    )
)