Forum Discussion
Helper ITotal for other players being displayed when it should not appear
Hi ompowerbi ,
I tried to reproduce your problem.
This is because the Player column in Table 1 is not equivalent to the Player column in Table 2. In other words, because the Player value in Table 2 does not exist in the Player in Table 1.
You could try to create a measure to solve it.
Measure = CALCULATE(SUM('Table 2'[Score]),FILTER('Table 2',[Player]=MAX('Table 1'[Player])))Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community ChampionHi ompowerbi the best practice would be to not have blank rows; to get it your table 1 and table 2 should be the same for key columns, meaning rows in two tables should be the same for connected columns. The rults of calculation later depending on your model, could be affected this blank rows. Go to your model and adapt changes in Table 1 (as table 2 have more rows). Hope this help
