Forum Discussion

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])

  • HenryJS's avatar
    HenryJS
    Post Prodigy
    5 years ago

    amitchandak  unfortunately this just returned the same result. see below

     

    • 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.