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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! 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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.