Relationship problem (CROSSFILTER?)

[jrscaletta]

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.

[parry2k]

@jrscaletta hey can you throw sample data in excel sheet and I can get you the solution.

[jrscaletta · Accepted solution]

Yes! I have a bad report filter configured. I deleted and it works! Thanks

[v-diye-msft]

Hi @jrscaletta 

Please kindly help mark the above answer as solution if it is helpful, others will benifit from it. thanks!