Forum Discussion

smmcqueen's avatar
smmcqueen
Frequent Visitor
4 years ago
Solved

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...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    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.

v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
4 years ago

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.