Forum Discussion
Relationship problem (CROSSFILTER?)
Hi all
My schema:
I need a measure that:
- Shows msdyn_projecttasks info that no has msdyn_actuals[msdyn_quantity] data.
- Show msdyn_actuals info that no has msdyn_projecttasks data.
I tried with:
hImputadasDetallTarea = CALCULATE(SUM(msdyn_actuals[msdyn_quantity]); CROSSFILTER(msdyn_actuals[_msdyn_task_value];msdyn_projecttasks[msdyn_projecttaskid];Both); CROSSFILTER(msdyn_projecttasks[_msdyn_project_value];msdyn_projects[msdyn_projectid];Both))
Not work nothing:
- Not appear msdyn_projecttasks info that no has msdyn_actuals[msdyn_quantity] data.
- Not appear himputadasDetallTarea info that no has msdyn_projecttasks data.
Photo:
If I use this measure:
hImputadas = CALCULATE(SUM(msdyn_actuals[msdyn_quantity]); USERELATIONSHIP(msdyn_actuals[_msdyn_project_value]; msdyn_projects[msdyn_projectid]); CROSSFILTER(msdyn_actuals[_msdyn_project_value]; msdyn_projects[msdyn_projectid]; Both ))
It shows:
- msdyn_actuals[quantity] that no have msdyn_projecttasks data: CORRECT.
But no shows:
- Not appear msdyn_projecttasks info that no has msdyn_actuals[msdyn_quantity] data.
How can I do?
Thanks in advance.
PD: parry2k I created a new post, because the last has marked as a solution and this is bit diferent. Sorry for the inconvenience.
Yes! I have a bad report filter configured. I deleted and it works! Thanks
3 Replies
- parry2kSuper User
jrscaletta hey can you throw sample data in excel sheet and I can get you the solution.
- jrscalettaHelper II
Yes! I have a bad report filter configured. I deleted and it works! Thanks
- v-diye-msftCommunity Support
Hi jrscaletta
Please kindly help mark the above answer as solution if it is helpful, others will benifit from it. thanks!