Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Can anybody help me figure out why this formula gives inaccurate result? and how do i make it correct?
Please provide sample data and what is your desired outcome in a table format
I just need to get the right value, multiplying the ITEMCOST and QUANTITY_RATE
@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")
Hello @amitchandak it's still not working and it's giving me same result from the formula i had first.
@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?
Still won't work. I just need to multiply the ITEM COST by the Quantity for those item that are ORG = SGW...
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |