Forum Discussion

romovaro's avatar
romovaro
Icon for Responsive Resident rankResponsive Resident
4 years ago
Solved

table connection not showing correct numbers

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

 

Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    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.

2 Replies