Relation Issue (I Think)

[alexsenso]

Hi, 

Im trying to im having an issue pulling the correct Figures for opportunities from Dynamics 365 i have modified the salesmanager.pbix with some sucess but i have a custom field which is an option set (opportunity type)  that i have loaded, I have then added a conditonal column so the guid is not used and i have a readable output, such as new business etc. 

This issue i have is that i see the readable output but the figures are all the same and not split as an amout  per Opportunity. Please see below link? Any pointers as to whats happening i think its to do with the opportunities I have loaded and the Opportunity table that already exists within the salesmanager.pbix. and their relationships? 

Thanks

this link is a screenshot of the visual for context

Link To Screenshot 

[v-xuding-msft]

Hi @alexsenso ,

The link is not effective. Can you please share a new one? Or you could share some pics directly. Then we will understand clearly about your problem.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[alexsenso]

Hi,

Thanks for the reply. 

Heres a new picture.