Function 'CONTAINSROW' does not support comparing values of type Text with values of type Integer.

[timward10]

Hi, 

I have the below error message, what should I do to enable this works? 

Thanks

[timward10]

Thanks @johnt75, I'll give it a go! 

[johnt75]

It looks like the [Assay Jan 24] column is a date and you are comparing it to text. Try 

Assay Cumulative Count =
CALCULATE (
    COUNTROWS ( 'Exent funnel by product' ),
    YEAR ( 'Exent funnel by product'[Assay Jan 24] ) = 2024
)

[timward10]

Hi @johnt75, 

It is a whole number column returning a revenue value, 

Thanks

[johnt75 · Accepted solution]

Then I think you're using the wrong column, you're comparing a revenue value to a text representation of a year month.

A better approach would be to create a proper date table, marked as a date table, then you can link that to your fact table and use year or year month filters on the date table in your measures.