Forum Discussion

jrscaletta's avatar
jrscaletta
Helper II
7 years ago
Solved

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

    • jrscaletta's avatar
      jrscaletta
      Helper II

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

      • v-diye-msft's avatar
        v-diye-msft
        Community Support

        Hi jrscaletta 

         

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