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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
bumoverflow
Frequent Visitor

Dimension result based on fact

Hello all

I encountered a problem that seems to be really bizzare.

I ahve a fact table and dimension table

bumoverflow_0-1684226995913.png

I insert in one table visualization id from fact table and I want to add customer_name as well. What happens is that I'm getting the same result for all rows

bumoverflow_1-1684227106671.png

First two columns come from fact table, the last one is from dimension (customer) table. I want to use customer to get name of customer but in order to do that I need Power BI to automatically assign proper values.

I already tried phew DAX solutions with selectedvalue function but non of them worked so far.

0 REPLIES 0

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors