I have two tables in my Power BI Report, Fact Table with directquery mode and dimension table with import mode. Fact table is joined to the dimension table through many to one relationship. I am trying to bring a column from the dimension table to the fact table but using the DAX Related function but it is not working. I am getting the following error
Error which i am getting
Relationship is shown below
I cannot use lookup to resolve this issue as i am using directquery in the fact table and i have to create a calculated column only
I am desperately looking for an answer..Can anyone please help in resolving this issue ?
I have a similar situtation where my Fact table is in Direct query and my Dimension table is import mode. Relationship between Fact to dimension table is Many to One.
I need to create a calculated column using some if condition where in I need to use my dimension table column. Unable to use Related DAX Function in the calculated column. its showing the similar Error message.
Any ways to resolve this issue or any other way to achieve to call the dimension column.