Forum Discussion

sagadgreat's avatar
sagadgreat
Helper I
5 years ago

USERELATIONSHIP

I have combed through several posts and cannot seem to find the answer I need.  First of all, based on everything I see, my request should be simple, but I wonder if the type of relationship is what ...
Need Help
Icey's avatar
Icey
Community Support
5 years ago

Hi sagadgreat ,

 

Can you show me some sample data or ceate a dummy .pbix file for test? Please don't contain real data and sensitive information.

 

 

Best regards

Icey

  • sagadgreat's avatar
    sagadgreat
    Helper I
    5 years ago

    Working on it. 

  • sagadgreat's avatar
    sagadgreat
    Helper I
    5 years ago

    So in creating this test sample, I noticed something in the data pull with the way I had it setup previously and made a basic fix.  I'm sending two versions.  

     

    Version 1: based on the original problem statement.  

    Note: (see below on version 2, if I attempted to resolve using this method, creating a separate relationship between the BD Parts file and sales files, I get a circular dependency)

    https://1drv.ms/u/s!ArmEo9mldkux9EBLdm4xJdCl9IW-?e=dPj7kW 

     

    Version 2: I removed the BD parts from the parts list and created relationships from the BD parts directly to sales.  I then was able to use the USERELATIONSHIP function properly.  The issue now is I cannot figure out how to display the alt parts for the original parts list on the same table without the duplication.  The end user needs to see both representations to know that the original item has an alt so they can click and filter accordingly (as displayed in version 1).  

    https://1drv.ms/u/s!ArmEo9mldkux9D-FA-pMgEgOeyNJ?e=Haol48 

     

    Thanks for any assistance you can provide.  I'm still working the issue on this side as well.