Forum Discussion

bswank31's avatar
bswank31
Icon for Helper II rankHelper II
2 years ago
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...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    Does this measure work?

    Measure = SUMX(VALUES(Data[Site]),[$/m * m])

bswank31's avatar
bswank31
Icon for Helper II rankHelper II
2 years ago

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

 

bswank31's avatar
bswank31
Icon for Helper II rankHelper II
2 years ago

I figured this issue out. 

thank you