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

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.