Rows from a related table are repeated when a caluclated measure is added to a view

[darklamp233]

Hi Team,

I'm having an issue in Power BI. When creating a table view with columns from the main table, including [CAGR] and Rating[Rating] from the joined table, the expected related value is not displayed. Instead, the rows are repeated with all values from the Rating table. This issue seems to stem from either the calculated measure or the join type, but the exact cause is unclear. Without either column, the table displays correctly.

Current dataset setup:

• The Rating table is linked to the main table using a one-way, many-to-one relationship.

• The main table includes a calculated measure, [CAGR].

Can anyone help on this?

Expected Result:

workbook 

[ryan_mayu · Accepted solution]

@darklamp233 

try to update the DAX to this

2-year CAGR = var cagr= iferror(power([24 Rev Sum]/[23 Rev Sum],(1/2)),1000)-1

return

switch (true(),

        not(ISBLANK([23 Rev Sum]))&& cagr <> 999, round(cagr,3),

        blank())

[darklamp233]

This solved the issue! Thank you for the help!

[ryan_mayu]

you are welcome