Forum Discussion

andywil456's avatar
andywil456
Advocate II
10 years ago
Solved

text to type error message

I'm trying to use a calculate formula to sum our out going per payment terms. The formula i'm using is CALCULATE(SUM('supplier pymt data'[Supplier Amount]),Table1[payment category]),   but i...
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    andywil456

     

    Try a measure like

     

    total =
CALCULATE (
    SUM ( 'supplier pymt data'[Supplier Amount] ),
    FILTER (
        'supplier pymt data',
        CONTAINS (
            Table1,
            Table1[payment category], 'supplier pymt data'[payment category]
        )
    )
)
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
10 years ago

andywil456

 

Try a measure like

 

total =
CALCULATE (
    SUM ( 'supplier pymt data'[Supplier Amount] ),
    FILTER (
        'supplier pymt data',
        CONTAINS (
            Table1,
            Table1[payment category], 'supplier pymt data'[payment category]
        )
    )
)