Power BI: Related function doesn't work even when there is active relationship RRS feed

  • Question

  • I have three tables and have proper relationships but the RELATED function isn't working. 

    Actually it was working fine but i accidentally deleted one of the table called dimbranch and then reloaded it again. I am using direct query method.

    Now one of the measure isn;t working. DAX for the measure as below:

    Client Branch = RELATED(v_DimBranch[Branch]) & " ~ " & RELATED(v_DimClient[ClientName])


    If i add these three tables into a fresh pbix then the dax works fine. I need this to work on my current pbix which has many other reports. 

    Can anyone please provide any insights?


    Wednesday, July 3, 2019 11:27 AM