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[ORGCODE] = "SGW")*(ASC[QUANTITY_RATE])
 

 

Need Help
Show and Tell
Tips and Tricks

7 Replies

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

  • smpa01's avatar
    smpa01
    Community Champion
    5 years ago

    Please provide sample data  and what is your desired outcome in a table format

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I just need to get the right value, multiplying the ITEMCOST and QUANTITY_RATE