Forum Discussion

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    HenryJS , Multiplication should be done at line level. If not use values or summarize to get correct total

     

    Sumx(Values(Table[Date]), [Multi Meaure])

     

    or

     

    sumx(summarize(Table, Table[Date], Table[Other grouping of visual] , "_1",[Multi Meaure]), [_1])

      • amitchandak's avatar
        amitchandak
        Super User
        5 years ago

        HenryJS , If possible, Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    5 years ago

    Hi HenryJS 

     
    Have you solved this problem? If solved, can you share your solution so that others have same problem can refer to it? If not, can you provide more details?
     
     
     

    Best Regards,

    Community Support Team _ Tang

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