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

RELATED function doesn't work

Hello, Power BI experts.

 

I've found myself in the strange position. After the July 2020 update some of my Direct Query report have broken visuals. The strange thing that I haven't changed anything, just opened them and found that all calculated columns with "RELATED" function are broken. How can it be? Did someone face this? All my RELATED functions are on the "many" side of "one-to-many" relationship. Don't understand what's going on. 

 

Thank you for your help and advice.broken visuals.png

 

3 REPLIES 3
Super User IV
Super User IV

@Leonid_Kostin , Can you share the formula used. Will try to test on a similar scenario.

 

Check if there are known issues - https://community.powerbi.com/t5/Issues/idb-p/Issues



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Hi again, @amitchandak !

 

I've found one interesting thing...So I checked 2 cases:

 

1. When I use my own created SQL statement to create a dataset (native query)

2. When I select the table from "New Source -> SQL Server -> ... " and then make some operations like filtering and ect.

 

In the first case I have an error during creation of the column using RELATED() function.

In the second case I don't have any issues.

 

So the method of loading data is important 🙂modelmodelno errorno errorerrorerror 

Hi, @amitchandak .

 

Thank you for your reply!

 

The formula is: 

Task Name = RELATED(TT_Tasks[Task Name])
 
Basically I try to grab a task name from the TT_Tasks to the dataset on the "many" side.
 
model.png
 
Same for Portfolio Name and User Name.
 
Pretty simple case but still don't understand why after the July update it doesn't work.
 
Thank you!

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