Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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:
Solved! Go to Solution.
try to update the DAX to this
Proud to be a Super User!
try to update the DAX to this
Proud to be a Super User!
This solved the issue! Thank you for the help!
you are welcome
Proud to be a Super User!
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
177 | |
85 | |
70 | |
63 | |
55 |