Calculate comparing two columns as a filter

[Henrique_Quint]

Hi, everyone.

Basically what I need is in the title. I have a table that needs to sum the revenue by store and month of another table. But I can't use lookupvalue because I have multiple brands of revenue on the same store. 

[Anonymous]

Hi, @Henrique_Quint 

Thank you for sharing the solution, your sharing will promote the development of the community. If you have any new questions in the future, you can continue to create new posts on the forum to ask questions.

Best Regards

Jianpeng Li

[Henrique_Quint · Accepted solution]

I figured it out myself!

What I did was use the DAX function FILTER. It turned out something like this: CALCULATE(SUM(TABLE2[REVENUE]),FILTER(TABLE2,TABLE2[MONTH]=TABLE1[MONTH]),FILTER(TABLE2,TABLE2[STORE]=TABLE1[STORE]))