Forum Discussion
jrscaletta
Helper II
Helper IIRelationship problem working with data from Dynamics365
Hi all. I'm unable to recover the data that I need from Dynamics365 PSA. I want to show in one matrix the data from 2 database tables. This is my structure: f Then, I use PR...
Ahh, that makes much more sense.
I added the following measure to your file, and added that as a value to the matrix. The numbers look right to me, but I don't know your dataset:
msdyn_quantity_measure = CALCULATE(SUM([msdyn_quantity]), USERELATIONSHIP(msdyn_journallines[_msdyn_task_value], msdyn_projecttasks[msdyn_projecttaskid]))
This measure is forcing the sum to use the relationship described instead of whatever the default active one is.
jrscalettaHelper II
Helper IIAnyone knows how to work with this type of relation?
Thanks in advance!
Cmcmahan
Resident Rockstar
Resident RockstarDid my solution not work? What issue are you still having?
- jrscaletta
Yes Cmcmahan , your solution works! All is ok! Thanks you so much!