Forum Discussion

sunah132's avatar
sunah132
Icon for Helper I rankHelper I
5 years ago

Rank and Partition

I have a list of items with pricing as value by delivery date. Because the direct query data has multiple duplicated entries per items, the row subtotal shows 10X more than what it should be. If I cr...
Need Help
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

sunah132 

I can't access to the link you shared. could you pls share via dropbox?

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    5 years ago

    sunah132 

    I can download your pbix file. what's the expected output?

    • sunah132's avatar
      sunah132
      Icon for Helper I rankHelper I
      5 years ago

      Hello,

      As the table below, I tried to see if I can add the MIN of Misc charge add up with the item cost if they were on the same delivery date. Thank you very much!

       

      • ryan_mayu's avatar
        ryan_mayu
        Icon for Super User rankSuper User
        5 years ago

        sunah132 

        you can try this

        Measure =
        var TBL=SUMMARIZE('Sheet1',Sheet1[Date],Sheet1[Item],Sheet1[Item code],"min",min(Sheet1[Item Cost])+min(Sheet1[Misc Cost]))
        RETURN SUMX(TBL,[min])