Forum Discussion

Titus_D's avatar
Titus_D
Helper I
4 years ago

Interconnected tables D365

Hi Experts, I am trying to connect D365 sales with PowerBI, its all connected and seems like we have to maually setup relationships between each table and i have done that as well. While visualising...
Need Help
Titus_D's avatar
Titus_D
Helper I
4 years ago

Adding more info.

This is how the model looks

This is how the data looks

 

The account data is accurate but the Opportunity data is not, it should be 85,77, 95,81 for each month respectively. 

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    Hi Titus_D ,

     

    Please try one of the following two ways.
    1. Change the relationship between the "accounts" table and the "opportunities" table to inactive, and then change the relationship between the "systemusers" table and the "opportunities" table to active.
    2. Use the following measure to calculate the opportunity value.

    Measure =
CALCULATE (
    SUM ( 'opportunities'[opportunityid] ),
    USERELATIONSHIP ( 'systemusers'[userid], 'opportunities'[userid] ),
    ALL ( 'accounts' )
)

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.