Error Message

[ArchStanton]

Hi,

I keep getting thrown everytime I see this type of error message - can someone help me re-write this please?
I will then create another 3 duplicates as I have 4 different Case Complexity category values (1-4) to apply.

Case Complexity 1 = CALCULATE(
    TOTALYTD(COUNT('Cases'[Case Number]),'Cases'[Resolution Date],"31/03"),
    'Cases'[statecode] = "Resolved",
    'OS Case Complexity'[Value] = 1)

Thanks,

[Anonymous · Accepted solution]

Hi @ArchStanton ,

Thanks for the reply from @rajendraongole1 , please allow me to provide another insight: 

Make sure that the filter expression involves only columns from a single table.
You can try the following expression.

CaseComplexity1 =
CALCULATE(
    TOTALYTD(
        COUNT('Cases'[Case Number]),
        'Cases'[Resolution Date],
        DATE(2024, 3, 31)
    ),
    FILTER(
        ALL('Cases'),
        'Cases'[statecode] = "Resolved"
    ),
    FILTER(
        ALL('OS Case Complexity'),
        'OS Case Complexity'[Value] = 1
    )
)

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ArchStanton]

[rajendraongole1]

Hi @ArchStanton - I have adjusted measure by adding Date(2024,3,31) in below mesure, can you try and check

CaseComplexity1 =
CALCULATE(
TOTALYTD(
COUNT('Cases'[Case Number]),
'Cases'[Resolution Date],
DATE(2024, 3, 31) 
),
'Cases'[statecode] = "Resolved" && 'OS Case Complexity'[Value] = 1
)

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[ArchStanton]

It didn't work, I got this error: