Forum Discussion
Decomp Tree Not Filtering Properly
The "Days Late" column and the last column are not in the same table. I have tried swtiching the relationship and filtering every wayt but nothing is working. Regardless of what I click on, the total value of "Days Late" is given for each value of the last column.
Hi smmcqueen ,
Typically, the total value is incorrect generally because the filtering context is incorrect. You can try to set the relationship between the two tables on the same fields and then cross filter direction as both.
You can share your pbix file without sensitive data if you need more help.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi smmcqueen ,
Typically, the total value is incorrect generally because the filtering context is incorrect. You can try to set the relationship between the two tables on the same fields and then cross filter direction as both.
You can share your pbix file without sensitive data if you need more help.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.