Dax having an error

Hi eryka_90 ,
Based on your description, you are trying to calculate the difference between what the provider will spend in total and what it has already spent. Where you want to show the data by each supplier. In your dax you are using the SUMMARIZE function, which always returns a table, which is why there are multiple columns reporting errors. Depending on your needs, the first thing you can do is put this dax into an expression that creates a new table. Or you can try the following dax

Update = 
CALCULATE(
    SUM('Vendor All Document'[Amount USD]),
    ALLEXCEPT(
        'Vendor All Document',
        'Vendor All Document'[Vendor]
    )
)-[# Total Paid Amount]

Fianl output

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly