cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Resolver II
Resolver II

Related function not working with Mixed Mode

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

jaideepnema_1-1594831416472.png

 

 

Relationship is shown below

 

jaideepnema_0-1594831366490.png

 

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 ?

 

1 ACCEPTED SOLUTION
Community Support
Community Support

Hi @jaideepnema ,

 

For mixed mode, you can create calculated column only on tables with import mode.

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

8 REPLIES 8
Helper I
Helper I

Hi Team,

 

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. 

 

Thanks in Advance.

Community Support
Community Support

Hi @jaideepnema ,

 

For mixed mode, you can create calculated column only on tables with import mode.

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

Super User III
Super User III

Hi @jaideepnema ,

 

Can you try modifying your relationship to bi-directional and check?

Also are their any NULL or BLANK values in Fkey column in both of your tables?

 

Thanks,

Pragati





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




@Pragati11 thanks for your reply

 

I tried changing the relationship to both direction it is still not working and giving the same error. Also there are no blanks or NULL values

Hi @jaideepnema ,

 

Is this a measure that you are creating?

I think yes it's a measure. So, measure needs a summarisation like SUM, AVERAGE, etc.

 

Try modifying your DAX for the measure as follows:

RelatedCheck = RELATED(SUM(DimPriceValue[Price]))

 

Thanks,

Pragati





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




@Pragati11 this is a calculated column i am trying to create and due to some calculation limitation i cannot create a measure

Hi @jaideepnema ,

 

You mentioned earlier you are using DirectQuery connection which is limiting you from creating columns.

 

Thanks,

Pragati





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Hi @Pragati11 ,

I am trying to create a calculate column and we can create calculated column in mixed mode as per my understanding  

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors