Forum Discussion
Helper ICalculate comparing two columns as a filter
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.
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]))
2 Replies
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_QuintI 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]))
