New measurement - total to date from count field

[Raimondas]

Hi, i need to calculate totals to date from *Count of SalesOrderNumber*, how do i do it, count number field is a count field ? My totals to date doesnt work:

Totals to date = CALCULATE([Count of SalesOrderNumber total for InvoiceCustomerAccountNumber], FILTER(ALL(SalesOrders[RequestedReceiptDate]), SalesOrders[RequestedReceiptDate] <= MAX(SalesOrders[RequestedReceiptDate])))

[v-yiruan-msft]

Hi @Raimondas ,

Please update the formula of your measure [Totals to date] as below and check if you can get the expected result If still not, please provide some sample data in table SalesOrders. Thank you.

Totals to date =
CALCULATE (
    [Count of SalesOrderNumber total for InvoiceCustomerAccountNumber],
    FILTER (
        ALL ( SalesOrders ),
        SalesOrders[RequestedReceiptDate] <= MAX ( SalesOrders[RequestedReceiptDate] )
    )
)

Best Regards

[Raimondas]

Hi,

currently it is like this: (while it should be as specified in black underline bold numbers)

[v-yiruan-msft]

Hi @Raimondas ,

Could you please provide some original data in table SalesOrders? And please provide the related formula of measure [Count of SalesOrderNumber total for InvoiceCustomerAccountNumber] and [Sales RT 2]? Is the measure [Sales RT 2] same with the previous measure/calculated column [Totals to date]? By the way, you are creating [Totals to date] as measure or calculated column?

I can get the correct result when I use your sample data and formula(see below screenshot)...

Best Regards

[lbendlin]

You already have YTD - that is your total.