Value of New Sales this year

[Tim_Walker]

Hi, I want to find the value of sales to new clients this year.  My table is Client Name, Invoice Date and Amount and the dates are spread over 2 fiscal years.  I simply need a measure (not a standalone table with filters) that I can add to a table showing the value of clients billed in Year 2 but not in year 1, but most importantly provides a total that I can use.  I have produced a number of measures which appear to give me the list, but none are able to produce a total.  Any help much appreciated...

[v-yulgu-msft · Accepted solution]

Hi @Tim_Walker,

Sum sales =
IF (
    CALCULATE (
        COUNTROWS ( data ),
        FILTER (
            ALLEXCEPT ( data, data[Client Name] ),
            data[Invoice Date].[Year] < YEAR ( TODAY () )
        )
    )
        < 1,
    CALCULATE ( SUM ( data[Amount] ), ALLEXCEPT ( data, data[Client Name] ) ),
    BLANK ()
)

Best regards,

Yuliana Gu