table connection not showing correct numbers

[romovaro]

HI all

I need some help regarding one table.

Current connections:

When I combine  the “Active Resources list” table with the “Weekly slippage” Table I am able to create the table showing CUIDs x month (Projects x month)  compared to the target and the difference between target and projects per month.

The problem I have with this table is that when projects are 0…target is not shown

I created a new table showing some “Active Resources lIst Colums + target by role” called Target by Associate table. When I combine the “Target by associate” table with the “Weekly slippage” Table I am able to create the table showing CUIDs x month (Projects x month)  compared to the target and the difference between target and projects per month.

The problem I have is that CUID per month x row = Total CUIDs for column. I get the same totals as the previous table but not showing correct numbers x row.

Any suggestion on how to show correct CUID numbers (Projects per month) and not totals?  

Thanks

[v-kkf-msft · Accepted solution]

Hi @romovaro ,

Please try to modify the cross-filter direction as shown below.

Then add the following fields and measure to the matrix.

M_Target = 
CALCULATE (
    SUM ( 'Target by Associate'[Target] ),
    USERELATIONSHIP ( 'Target by Associate'[Role], 'Active Resources list'[Role] )
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@romovaro , Many to Many join is not a good idea, Why there is Many to Many join with resources?

In case you need SCD

Guyinacube - https://www.youtube.com/watch?v=tKeaQpWynzg

https://www.youtube.com/watch?v=E1ZABKBpkdg

https://www.zartis.com/scd-implementation-with-temporal-tables-in-power-bi/