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

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    No one could help you well without sample data and expected output. Is the ASC[QUANTITY_RATE] a measure or a column?

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai