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

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

Accepted Solutions
Highlighted
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
Highlighted
Super User II
Super User II

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!




Highlighted

@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

Highlighted

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!




Highlighted

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

Highlighted

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!




Highlighted

Hi @Pragati11 ,

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

Highlighted
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

Highlighted
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.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors