Forum Discussion

BillyT_350's avatar
BillyT_350
Icon for Helper V rankHelper V
3 years ago

Measures forgetting SELECTEDVALUE?

Hello community. I have a problem where some measures based on other measures appear to be forgetting omnipresent SELECTEDVALUEs.   Most of my reports allow basic unit of measure conversion by sele...
Need Help
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
3 years ago

Hi BillyT_350 

 

Well this is somewhat complicated. Can you first test if all measures work well when the first measure does not have "Select a quantity!" as the alternative value? 

 

Since the measure is used in other measures, usually all possible results returned by it are expected to have the same data type to avoid data type not matching error. 

 

Otherwise you may try IFERROR function instead. 

 

Best Regards,
Community Support Team _ Jing

  • BillyT_350's avatar
    BillyT_350
    Icon for Helper V rankHelper V
    3 years ago

    v-jingzhang, I may try hard-coding a filter into some of the calculations to see if they will work. The thing is that I have that error message in the SELECTEDVALUE() for a reason; users crunch the dataset in Analyze in Excel as well, and they need that error message to remind them. If a UOM is hard-coded into some measures, then some users may end up comparing apples to oranges.
    I've also filed ticket 2211030040007196 to see if some MSFT folks and I can troubleshoot this together; this seems buggy to me.