undefined

[Anwo_Maryam]

• 

  My year(1996 and 1997) sum of gross sales are showing the same value as my total sum of sales on my power I table view.

• How do I solve this problem in such way that sum of gross sales for year 1996 will be in the of 1996 and also the same thing for 1997???

[Anonymous]

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.

[AmiraBedh]

Maybe there is no relationship between your fact table and your date table?

Can you share your model?

[Anwo_Maryam]

There

There's a relationship between my fact table and years.

[Anwo_Maryam]

This is also popping up anytime I choose years in my report view