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!

v-xulin-mstf's avatar
v-xulin-mstf
Icon for Community Support rankCommunity Support
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!