Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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


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


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.


Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors
Users online (716)