Forum Discussion
measure question
I have 2 fact tables - sales and opportunity. I want to show by opptunity ID, the sales revenue, and sales rev total. I have a measure, however this measure does not give me the total. M_To...
In total, there wont be any filters on ID and selectedvalue() function can give blank as a output. Which means the variables Acct and OptyProd value is blank. I guess this is the reason for a blank value in the total.
Could you explain the reason for using selectedvalue function inside an SUMX iterator?