Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Fixed LOD

Hello,   Can anybody help me figure out why this formula gives inaccurate result? and how do i make it correct?     Fixed Item = CALCULATE(SUM(ASC[ItemAttributes_ITEMDIM.ITEM_COST]), ASC[ORGCOD...
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous ,  Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. As most us not so familar Tableau .

 

Please try


Fixed Item = CALCULATE(SUMX(ASC,ASC[ItemAttributes_ITEMDIM.ITEM_COST]*ASC[QUANTITY_RATE]), ASC[ORGCODE] = "SGW")

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello amitchandak it's still not working and it's giving me same result from the formula i had first.

     

     

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      Anonymous , I think you need multiplication at some level say item

       

      try like

       

      Fixed Item = CALCULATE(sumx(values(ItemAttributes_ITEMDIM[ITEMDIM])calculate( SUM(ASC[ItemAttributes_ITEMDIM.ITEM_COST])*Sum(ASC[QUANTITY_RATE]))), ASC[ORGCODE] = "SGW")

       

      Can you share sample data and sample output in table format?

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Still won't work. I just need to multiply the ITEM COST by the Quantity for those item that are ORG = SGW...