Fixed LOD

[Anonymous]

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])

[smpa01]

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

[Anonymous]

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

[amitchandak]

@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]

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

[amitchandak]

@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]

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]

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