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]
        )
    )
)
Nhallquist's avatar
Nhallquist
Helper V
10 years ago

Dax isn't my native language, but I'm pretty sure that CALCULATE is a function where you filter the table results for a specific value.  The error is telling that you it can't evaluate your filter expression for the CALCULATE function.  A good site to use for DAX Expressions is here and a definition for CALCULATE is below.

 

 

CALCULATE(<expression>,<filter1>,<filter2>…)Evaluates an expression in a context that is modified by the specified filters.

 

Nate