Fetch Data with no active relation

Hi yogeshk77 ,

You are using calculated columns as a context, so you need to use the EARLIER function. Based on your sample, I get the following results:

DAX for New column:

AHA WSJF Score =
VAR CurrentProjectName = [PO Project Name]
RETURN
       CALCULATE(
        MAX('Aha Features'[Feature product value score]),
        FILTER('Aha Features', 'Aha Features'[POProjectNameCleaned] = EARLIER(Features[PO Project Name])),ALL(Features))

I've also created a Measure for you that does the same thing, which you can download as an attachment.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.