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

2 Replies

  • 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

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