Measure Incorrectly Passing Value to New Measure

[austinb97]

Hi, I am having problems feeding the result of "Measure 1" below into "Measure 2". I do get the correct result of 8921 from "Measure 1", but "Measure 2" is not reading that number correctly. Notice in "Measure 3" I hardcode in the 8921 and I get the correct result, but when I reference the measure I get the incorrect result. I'm thinking it either has to do with my variable or the ALLSELECTED portion of "Measure 1". I am using a slicer to pick an "AssetName" then doing a sum of "Available MW". Any suggestions on how to fix this? 

Measure 1 (Gets correct result)

Measure 2 (Produces Incorrect Result)

Measure 3 (Produces Correct Result)

[v-xulin-mstf · Accepted solution]

Hi @austinb97,

Without your data structure, I can't determine the exact filtering conditions, but in any case, you have to make sure the filtering conditions for measure1 and measure2 are the same.

Try measure as:

MINX(
     FILTER(ALLEXCEPT(MERITORDER,MERITORDER[DATE]),MERITORDER[CUMULATIVE AVAILABLE MW]>=[MEASURE1]),
     MERITORDER[PRICE]
)

If you still have some question, please provide the pbix file after removing sensitive information.

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[amitchandak]

@austinb97 , You are trying to use measure in a filter then you have to force a context using summarize or values

example

sumx(filter(values(Table[ID]), [Measure] > max(Table1[Col1])),[Measure])

[austinb97]

Thanks, however I'm not sure how to apply that to my measure, any suggestions on how to rewrite it?