Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
darklamp233
New Member

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

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:

darklamp233_0-1736802770539.png

 

 

 

workbook 

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@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())
 
11.PNG




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
ryan_mayu
Super User
Super User

@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())
 
11.PNG




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




This solved the issue! Thank you for the help!

you are welcome





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.