ACW DurationFormatted Not Showing in Table

Hi All,

My Table Structure:

* I have two relevant fields:
* `Weekday`: Formatted using `FORMAT([IXN_SUBHOUR_DATE],"DDD")`
* `ACW DurationFormatted`: Calculated column using formulas to convert seconds to HH:MM:SS format.

The Problem:

When I drag `ACW DurationFormatted` into the table, it doesn't display for specific weekdays selected in the `Weekday` slicer. Instead, the `Weekday` seems to split with duplicate entries.

Understanding the Issue:

I believe this might be due to how calculated columns interact with slicers and filter context. The `ACW DurationFormatted` column was likely calculated before filtering by weekdays, resulting in entries for all weekdays even after filtering.

Do you have any other suggestions or preferred approaches for this scenario?

ACW Hours = INT([ACW_DURATION] / 3600)
ACW Minutes = INT(MOD([ACW_DURATION], 3600) / 60)
ACW Seconds = MOD([ACW_DURATION], 60)

ACW DurationFormatted =
FORMAT([ACW Hours], "00") & ":" &
FORMAT([ACW Minutes], "00") & ":" &
FORMAT([ACW Seconds], "00")

Weekday = FORMAT([IXN_SUBHOUR_DATE],"DDD")

Thanks again for your assistance!
Manoj Prabhakar