topic Re: Fetch Data with no active relation in DAX Commands and Tips

Fetch Data with no active relation

yogeshk77 — Mon, 16 Oct 2023 09:23:28 GMT

Hi All,

Please refer to this Power BI File

I have a table called "Aha Features" with two fields (Shown in the report)

Now, there is another table called "Features" (also show in the report), that does not have active relationship with the column with similar name in "Aha Features" table.

Now, I need to show Score in "Features" table (In field called "AHA WSJF Score") ,but the calculated column I have added, isn't working (Showing blank values for all rows as seen in the table visual for "Feature" table visual).

The problem may be because of the relationships between "Epic" table & "Aha Features" on the same column as that between "Features" and "Aha Features" table.

What's the solution?
Can someone please help me?

Re: Fetch Data with no active relation

Anonymous — Tue, 17 Oct 2023 06:23:50 GMT

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.

Re: Fetch Data with no active relation

yogeshk77 — Tue, 17 Oct 2023 07:54:47 GMT

Brilliant !!! Thanks a lot !