Forum Discussion

Gopinath_iyer's avatar
Gopinath_iyer
Icon for Helper II rankHelper II
5 years ago

help in calculation

Hi All,   I need you help/suggestion in acheiving the below result. my data has multiple rows for a product with same amount repeating. How would i show the category wise sum of amount but each pro...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Gopinath_iyer , Create a measure like

 

sumx(summarize(Table,[Category],[Product],[Amount]), [Amount])

 

or remove duplicate in power query

  • Gopinath_iyer's avatar
    Gopinath_iyer
    Icon for Helper II rankHelper II
    4 years ago

    Thanks creating measure worked