Forum Discussion

bhmiller89's avatar
bhmiller89
Helper V
9 years ago

Transitive Relationships

I'll try to make this coherent:   I have the following relationships created. I need to write measures to calculate the quantity of Notes entered by the following roles: 1. CustServiceRepID 2. PM...
Need Help
bhmiller89's avatar
bhmiller89
Helper V
9 years ago

Anonymous I have Organization Name, TSM, PM, and COL.  Basically the roles that I need to calculate quantity for

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi bhmiller89,

 

Could you share a sample pbix file which can reproduce the issue in this case? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.:smileyhappy:

 

Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I know this is old but apparently still actual. Sharing my template (unfortunately, thanks Excel, the data model seems to be broken but at least the tables are there): https://1drv.ms/x/s!AjBnB9hwJU8wgdQ6kT6QnLaF4hTeNw?e=qlI8KO
    In which we start from this model:

    (colored tables being the ones with unique values/references used as key for relationships)
    So desired outcome would be to have:

    insted of:

     




    Thx!

    PS: Crossjoin is not a solution because it generates duplicate rows making the sum of revenue fake.