Summed Table - Cannot replicate table measure

[HankScorpio2]

Hi

I am trying to replicate a "measure". It's in inverted quotes as it doesn't behave like a measure and looks more like a table symbol with a summation on it.

See Screenshot.

I want to replicate that summation from the 2024 table in the 2025 table.

If I try to create it by creating a measure or a column it fails.

The code is 

Weekday to complete = SUMX(FILTER('Date', 'Date'[Date] >= 'Mail Apps 2024'[Received] && 'Date'[Date] <= 'Mail Apps 2024'[Completed Date]), 'Date'[is work day])

What is it? And how do I replicate it?

[v-karpurapud · Accepted solution]

Hi @HankScorpio2 

Thanks for reaching out to the Microsoft Fabric Community Forum.

By reproducing the scenario using a sample dataset.

To resolve the issue, here is the modified DAX formula .

DAX:

Weekday to complete 2025 =

SUMX(

    FILTER(

        'Date',

        'Date'[Date] >= SELECTEDVALUE('MailApps2025'[Received]) &&

        'Date'[Date] <= SELECTEDVALUE('MailApps2025'[Completed Date])

    ),

    'Date'[is work day]

)

After applying the above DAX formula in the Table visual, here is the output:

This approach resolved the issue of ambiguity in the measure, allowing for filtering the Date table correctly and calculating the total number of workdays between the specified date range.

If you have any further questions or need additional help with this, feel free to reach out     to us for further assistance!

If you find this post helpful, please mark it as an "Accept as Solution" and give a KUDOS.

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but if you are trying to create a calcualted column in 'Mail Apps 2025' table, please try something like below and check whether it works.

Weekday to complete =
SUMX (
    FILTER (
        'Date',
        'Date'[Date] >= 'Mail Apps 2025'[Received]
            && 'Date'[Date] <= 'Mail Apps 2025'[Completed Date]
    ),
    'Date'[is work day]
)