Forum Discussion

Henrique_Quint's avatar
Henrique_Quint
Icon for Helper I rankHelper I
1 year ago
Solved

Calculate 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 o...
Need Help
  • Henrique_Quint's avatar
    Henrique_Quint
    1 year ago

    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]))

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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