undefined

Thanks for the reply from AmiraBedh , please allow me to provide another insight:
Hi  Anwo_Maryam ,

Is [Sum of Gross Sales] a calculated column or a measure? If it is a measure, the measure follows the context of the ‘Total’ row and calculates within that context. Therefore, the measure used in the columns of the table visualization may have unexpected values in the ‘Total’ column.

You can try using the following measure：

Correct total =
var _table=SUMMARIZE(' AutoCalendar',' AutoCalendar'[Year],"Value",[Sum of Gross Sales])
return
IF(
    HASONEVALUE(' AutoCalendar'[Year]), [Sum of Gross Sales],SUMX(_table,[Value]))

According to the error message, if [Years] is a text type and [orderDate] is a date type, according to the design of power bi, the two different types can not be compared,, you can consider creating a [Year] in Fact Table to make a connection.

This is the related document, you can view this content:

Solved: cannot convert value of type text to type Date - Microsoft Fabric Community

Solved: Power BI Error - Cannot convert text into date typ... - Microsoft Fabric Community

Best Regards,

Liu Yang

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