Forum Discussion
Solved
measure issue with multiplying two fields; giving me wrong total
HI. I hope someone can help me out with an issue. I have a table of sites that shows YTD drilled meters and the cost per meter for that project that comes straight from a data source. What I am tryin...
Hi,
Does this measure work?
Measure = SUMX(VALUES(Data[Site]),[$/m * m])
Thanks for getting back to me. That is frustrating that the total does not work the way it should. I understand what is happening, I just can't quite get it to work. Still newish.
I have created my measure that multiplies my total drilled meters by my average $/m to give me my cost per project. What would I need to do to get the total and subtotals to come out correctly. The total for site 1 and 2 should be 5,812,118.904 and not the 6,382,345
again, your help is much appreciated.
thanks a bunch
Hi,
Does this measure work?
Measure = SUMX(VALUES(Data[Site]),[$/m * m])
Hi, I have ran into another issue. I have created a measure:
Meters w/costs program = SUMX(VALUES(Drill[Program]),Drill[>0 program cost/m])and it is giving me the correct values but how would I get the correct total for that new measure created? that total should be 7,341I figured this issue out.
thank you