Column sum issues

[wl280873]

Hi,

I've looked at the various solutions and none seem to work. It's the standard issue, that the sum at the bottom, or categoery, is way above what it should be. I've tried the hasonefilter etc, but still no joy. I'm using two tables, though not sure if this is the issue, so it's a rate in one and a quantity in another, multiplying to give an overall total.

code costs = if(HASONEFILTER(Data[Job Task Description]),SUM(Data[Quantity])*SUM('std costs'[Unit Cost (LCY)]))

[Anonymous]

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[wl280873]

Hi,

Thanks, though that's not answering the question though is it!?