text to type error message

[andywil456]

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'm getting the following error message in relation to payment category

Cannot convert value '0.1 Pre payment' of type Text to type True/False.

[Eric_Zhang · Accepted solution]

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

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