Forum Discussion

ARob198's avatar
ARob198
Icon for Helper IV rankHelper IV
6 years ago
Solved

Create a measure which sums values based on a filter in another table

Hello!  I have a problem that seems like it should be easy, but I can't seem to get the formula right.    I have two tables.  One has values by asset by date, the second defines the type of asset...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    6 years ago

    If you already have the relationship, then all you should need to do is to restrict the Type to Cash.

     

    SumCash = CALCULATE ( SUM ( Table1[Value] ), Table2[Type] = "Cash" )
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi ARob198 ,

    You can create a measure as below on the premise that Table 1 and Table 2 have created a relationship based on Name field:

    SumofValue = CALCULATE(SUM('Table1'[Value]),ALLEXCEPT('Table2',Table2[Type]))

    Best Regards

    Rena

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi ARob198 ,

You can create a measure as below on the premise that Table 1 and Table 2 have created a relationship based on Name field:

SumofValue = CALCULATE(SUM('Table1'[Value]),ALLEXCEPT('Table2',Table2[Type]))

Best Regards

Rena