Forum Discussion

austinb97's avatar
austinb97
Regular Visitor
5 years ago

Formula in measure not working as expected

Hi,    I have attached images and labelled 4 measures below and the resulting output. Measure 1 and 2 are related, and measure 3 and 4 are related. Measure 1 and 3 are similar and measure 2 and 4 a...
Need Help
austinb97's avatar
austinb97
Regular Visitor
5 years ago

Thanks, however this does not appear to fix my issue with the BLANK getting returned. I just can't understand why Measure 2 works correctly and Measure 4 does not with essentially the same logic. 

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
5 years ago

What if you replace [Fake Dispatched Available MW] with the hardcoded value 8953? Do you get a non-blank or are you just filtering out the whole table?

 

Note: You are playing with fire having ALLSELECTED inside of a FILTER iterator. ALLSELECTED is really complicated to understand in such situations.

  • austinb97's avatar
    austinb97
    Regular Visitor
    5 years ago

    I appreciate the suggestion. You can see the result below, it does work as expected in this case. There is just some sort of issue with how the measure is being passed into this formula. When its hardcoded in, then it works. Any idea how to rewrite my "Measure 3" from above? You are probably correct that its the ALLSELECTED causing the issue. Basically I am using a slicer to choose an "AssetName" then I want it to sum the corresponding "Available MW" and pass it into my "Measure 4"

     

    • AlexisOlson's avatar
      AlexisOlson
      Icon for Super User rankSuper User
      5 years ago

      It's doesn't make sense to me why this works but my initial suggestion doesn't if 8953 is the result of a working Measure 3.

       

      Does anything change if you use VALUES instead of ALLSELECTED? If you don't have filter context from the visual (e.g. rows/column in a matrix), these should behave similarly.