Forum Discussion

austinb97's avatar
austinb97
Regular Visitor
5 years ago
Solved

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 i...
Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    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's avatar
amitchandak
Super User
5 years ago

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's avatar
austinb97
Regular Visitor
5 years ago

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