Forum Discussion

Anwo_Maryam's avatar
Anwo_Maryam
Regular Visitor
2 years ago

undefined

  • 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???
Need Help

4 Replies

  • AmiraBedh's avatar
    AmiraBedh
    Super User
    2 years ago

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

    Can you share your model?

    • Anwo_Maryam's avatar
      Anwo_Maryam
      Regular Visitor
      2 years ago

      There

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

      • Anwo_Maryam's avatar
        Anwo_Maryam
        Regular Visitor
        2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.