Forum Discussion
Helper ISUM based on multiple filters from different tables
Hello AmudhaKumaran ,
If Table 1 and Table 2 have any relationship between the two, you can try using RELATED DAX to apply the filter on Table 2.
Just found a very useful video targetting the same problem:
https://www.youtube.com/watch?v=Wu1mWxR23jU
See if this helps.
If you want the filters from table2 to filter table1, there must be a relationship path to pass these filters to table1. You can check the relationships in your model to make sure there is a path can pass filters from table2 to table1. Then your dax formula can works well.
Best Regards
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community ChampionHello AmudhaKumaran ,
If Table 1 and Table 2 have any relationship between the two, you can try using RELATED DAX to apply the filter on Table 2.
Just found a very useful video targetting the same problem:
https://www.youtube.com/watch?v=Wu1mWxR23jU
See if this helps.
Advocate IIf using a measure TREATAS is a better option. I think you need a relationship between the tables but it doesn't need to be active.
An example
SalesAmountFiltered =
CALCULATE (
SUM ( Sales[SalesAmount] ),
TREATAS (
VALUES ( Products[Color] ),
Sales[ProductColor]
)
)