I have a measure that works properly on each row, but does not show the total for all of the rows in the table. I need to multiple MBOE by NRI and divide the measure by 100. The Data Category for this measure is greyed out, so i can't force it to show a Sum.
NRI_MBOE = IF(HASONEVALUE('Cost Centers'[Cost Center Key]), CALCULATE(VALUES(EUR_BOE[MBOE])*VALUES('Well Info'[NRI])/100), BLANK())
I figured out that the calculation for NRI_MBOE is taking the total for each column, so it is using the sum of the NRI (which i don't want). I should back up and start from the beginning on my full needs...
I need a Total Drillbit F&D = (Total sum of WI_DCC/Total sum of NRI_MBOE/1000)
*This measure should take the sum of WI_DCC coumn, divide by sum of NRI_MBOE column & divide by 1000.