Forum Discussion
Measure Incorrectly Passing Value to New Measure
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)
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!
3 Replies
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])
Thanks, however I'm not sure how to apply that to my measure, any suggestions on how to rewrite it?
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!
