Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
1 year ago
Solved

Help with Date Filter needed

Hi,   The code below produces the wrong values in my Matrix visual (the Resolution Table = is a Date - Calendar Table). YTD Closed Cases 6 = CALCULATE ( TOTALYTD ( COUNT ( 'Cases'[Case Numbe...
Need Help
Show and Tell
  • v-aatheeque's avatar
    v-aatheeque
    1 year ago

    Hi ArchStanton,
    First, create a base measure for Resolved Case Count:

    Resolved Case Count = 
CALCULATE(
    COUNT('Cases'[Case Number]),
    'Cases'[statecode] = "Resolved",
    'Cases'[Resolution Date] > DATE(2025,3,31)
)

    Then, use TOTALYTD on top of this base measure:

    YTD Closed Cases FINAL = 
TOTALYTD(
    [Resolved Case Count],
    ResolutionTable[Date],
    "31/03"
)


    Hope this helps !!

    If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

    If you continue to face issues, feel free to reach out to us for further assistance!



     

v-aatheeque's avatar
v-aatheeque
Icon for Community Support rankCommunity Support
1 year ago

Hi ArchStanton,
First, create a base measure for Resolved Case Count:

Resolved Case Count = 
CALCULATE(
    COUNT('Cases'[Case Number]),
    'Cases'[statecode] = "Resolved",
    'Cases'[Resolution Date] > DATE(2025,3,31)
)

Then, use TOTALYTD on top of this base measure:

YTD Closed Cases FINAL = 
TOTALYTD(
    [Resolved Case Count],
    ResolutionTable[Date],
    "31/03"
)


Hope this helps !!

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

If you continue to face issues, feel free to reach out to us for further assistance!



 

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
1 year ago

Thanks for this - much appreciated!